Dialog Box upon opening

  • Thread starter Thread starter jamphan
  • Start date Start date
J

jamphan

I would like a dialog box to appear when the user opens the workbook to
give some instructions and then have them click OK when they have read.
Can you please provide me the instructions on how I can achieve this.
Thanks for the help!
 
You could use Workbook_Open code to pop up a message box or userform when the
file is opened.

The running of this code would mean that users must not diable macros or the
code would not run.

Also would mean the users get the "macros" warning unless you digitally signed
the code.

Sub Workbook_Open()
msgbox "do this then do that"
End Sub

For more on UserForms see John Walkenbach's site

http://www.j-walk.com/ss/excel/tips/userformtips.htm

Maybe "splash screen" would work, although it has a timer.


Gord Dibben Excel MVP
 
Back
Top