Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
msgbox prompts?
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 |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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 |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
msgbox prompts?
Lose the comma and add a colon!
ActiveDocument.Close savechanges:=False -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org jatman wrote: 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 |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
msgbox prompts?
once again, THANK YOU
jat "Graham Mayor" wrote: Lose the comma and add a colon! ActiveDocument.Close savechanges:=False -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org jatman wrote: 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MsgBox during merge | Mailmerge | |||
Prompts without Mailmerge | Microsoft Word Help | |||
Get rid of paragranph and other prompts | Microsoft Word Help | |||
MsgBox Bold Property? | Microsoft Word Help | |||
Prompts | Microsoft Word Help |