Pop-Up Message Box

  • Thread starter Thread starter Tom
  • Start date Start date
T

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
 
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
 
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.
 
Sub Auto_Open()

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)
 
That works great!!!

Tom


Frank Kabel said:
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
Click to expand...
 
Thanks for the info... works for me!

Tom


Norman Harker said:
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.
Click to expand...
 
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
 
Back
Top