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!


--
jamphan
------------------------------------------------------------------------
jamphan's Profile: http://www.excelforum.com/member.php...o&userid=20105
View this thread: http://www.excelforum.com/showthread...hreadid=470895

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



On Mon, 26 Sep 2005 15:16:08 -0500, jamphan
<(E-Mail Removed)> wrote:

>
>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!