Thread: msgbox prompts?
View Single Post
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
jatman jatman is offline
external usenet poster
 
Posts: 12
Default msgbox prompts?

ok, ignore the initial request, because i have most of it figured out now. i
only have one issue left (there's always one issue left)

the document is a macro enabled word template (Office 2007)

in the macro i have the following code:

Application.DisplayAlerts = wdAlertsNone
ActiveDocument.Close , SaveChanges = False

what i would like is the template to close without any prompts or alerts -
just shut down the template. no matter how i write these lines, i always get
the SaveAs dialogue box!

any suggestions on how to just shutdown the tempalte without any SaveAs boxes?

thank you,

"jatman" wrote:

my first macro word form is almost done. i have one question now. where can
i find information on msgbox messages, prompts, and if then rules for msgbox.


example:

msgbox #1 Help or Ok vote buttons

Help button gives instructions msgbox with OK button only. when OK is
pressed, document closes.

OK from msgbox #1 gives new message box #2 with YES/NO options. if Yes
then msgbox closes and user uses document. if NO then user gets msgbox with
OK button only, when OK is pressed msgbox closes, and user uses document.

this is what i have so far:

msgbox "Users must enable the Word macros prior to the first use. press
OK to continue, or Help for detailed instructons", vbMsgBoxHelpButton
If userinput = OK Then
msgbox "have you used this form b4?", vbYesNo
If userinput = No Then
msgbox "instructions for form macro"
End If
End If

jat