Pop-Up Message Box

[Tom]

I have a spreadsheet that requires user input.

The process for the user input is relatively easy and straightforward, yet
it is critical that the understand the "directions" that they are given on a
a "ReadMe" worksheet tab.

The ReadMe worksheet is set to be the "default worksheet" when they open the
spreadsheet. However, I am confident that most user simply ignore it and
immediately skip to the data collection worksheet.

To prevent this, is there a chance to create some kind of "dialog message
box" that pops up when Excel opens the file. This message then can
reiterate the importance of the ReadMe worksheet and the dialog box can be
closed via clicking on the X in the top-right corner.

Any suggestions???

Thanks,
Tom

 

[Frank Kabel]

Hi
put the following code in your workbook module (not in a standard
module):


Private Sub Workbook_Open()
msgbox "please read the first page!!!!"
End Sub

 

[Norman Harker]

Hi Tom!

One way would be to use a Workbook_Open event handler that shows a
User Form

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Bob Phillips]

Sub Autpen()

Msgbox "It is important to do this properly, do you understand?",
vbYesNo

End Sub

or something like

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Tom]

That works great!!!

Tom

Hi
put the following code in your workbook module (not in a standard
module):


Private Sub Workbook_Open()
msgbox "please read the first page!!!!"
End Sub

 

[Tom]

Thanks for the info... works for me!

Tom

Hi Tom!

One way would be to use a Workbook_Open event handler that shows a
User Form

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Tom]

Thanks, works smoothly.. just like the others..

Tom

 

[Julian Moore]

You could try this: hide the sheets you don't want
accessed until and unless the user has indicated they
have seen the appropriate message.

Julian