View Single Post
 
Old 09-25-2011, 10:02 PM
Frogggg Frogggg is offline Windows Vista Office 2007
Novice
 
Join Date: Aug 2010
Posts: 10
Frogggg is on a distinguished road
Default How to idiot proof a certificate

How do I create (upon opening of template) a dialog box that asks the viewer five questions eg description, recipient, department etc and then takes these answers and populates a certificate in styles/formatting of only my choosing. I do not want them to to touch the document in anyway as they will kill the formatting. I have tried a basic user form but I think they will not complete it properly. If I use a macro that returns an error if they have not completed all five questions i will be on the right track. I have searched but am confused as to what macro I should be using or whether there is even a better/easier way than a macro.
Reply With Quote