Thread: [Solved] On Open MsgBox for use in Template sent out to colleagues to gather information
View Single Post
 
Old 10-26-2015, 06:22 AM
Lancashire Lad Lancashire Lad is offline Windows 7 64bit Office 2013
Novice
  
Join Date: Oct 2015
Posts: 2
Lancashire Lad is on a distinguished road
Default On Open MsgBox for use in Template sent out to colleagues to gather information
I have limited VBA skills. I have created an MS Word form that I want to send out to gather information. Editing on the form is restricted so data can only be entered in the fields. The form is saved as a Word Macro-Enabled Template (.dotm) as I want to have a simple message box pop-up on open to instruct the user how to use the form. I can create the VBA and run this on demand to show the message box but I can't work out how to automate this. When the recipient open the form I would like the message to display. I also need to know how to 'manage' the macro warning that will undoubtedly pop up on the user's screen.

Windows 7 64bit SP1
Office 2013 Professional

All advice gratefully received - thanks.
Reply With Quote