#1   Report Post  
Posted to microsoft.public.word.docmanagement
jatman jatman is offline
external usenet poster
 
Posts: 12
Default 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   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

  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default 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   Report Post  
Posted to microsoft.public.word.docmanagement
jatman jatman is offline
external usenet poster
 
Posts: 12
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MsgBox during merge Kathy Webster Mailmerge 7 May 18th 07 07:47 AM
Prompts without Mailmerge Sondra Microsoft Word Help 2 December 12th 06 04:01 PM
Get rid of paragranph and other prompts iamhere Microsoft Word Help 2 August 29th 06 02:48 PM
MsgBox Bold Property? A.Sorto Microsoft Word Help 2 March 29th 06 04:09 AM
Prompts Julie Microsoft Word Help 1 November 17th 05 10:23 AM


All times are GMT +1. The time now is 02:28 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"