View Single Post
 
Old 10-27-2013, 06:34 AM
dbs179 dbs179 is offline Windows XP Office 2010 32bit
Novice
 
Join Date: Oct 2013
Posts: 10
dbs179 is on a distinguished road
Default

Quote:
Originally Posted by Charles Kenyon View Post
You could store your variable language in AutoText in your template.
Each checkbox should be assigned a bookmark name. Your code tests for its value, and based on the value inserts code.

See Doug Robbins' answer in this thread for sample vba code for an on-exit macro for your checkboxes. http://social.technet.microsoft.com/...do-not-display

Rather than a protected form or in addition to it you might want to consider using a UserForm which has the advantage of not needing to have your checkboxes in the final document. Create a Simple Userform
Create & Employ a Userform

Charles,

I'll look into the on-exit macro you mentioned and thanks for the idea about the Userform, but like I said, I didn't develop the template and it has already been sent out.

Thank you for the idea though, I'm going to check out that link as well and perhaps it will come in handy for the next revision of this project.

Dave
Reply With Quote