ExcelBanter - Opening Files to Dailogue Box

I'll give you the general requirements, and if you need more help with any,
just let us know.

You need to go into the VB Editor and create your user form with the
instructions and the "I've read this" button. The button should have a line
in it
Me.Hide
to close the form.

Once you have the form created, use the workbook's _Open() event to display
the form when the workbook is opened (each and every time it's opened, no
matter how many times a person has seen the form). If your form's name is
UserForm1 then this line of code in the Workbook_Open() event will bring it
to view

UserForm1.Show

Remember that if their Macro Security level is set to HIGH, neither this nor
any other code is going to run at all. If the Macro Security is set to
Medium, they'll have the option to let it run (and see the form) or not, and
if they hold the [Shift] key down while opening the workbook, the
Workbook_Open() code won't run although other macros may.

Hope this gets you going in the right direction.

"Mark63" wrote:

Hi. I'm using Excel 2002 and am trying to get an excel file to open to a
dialogue box which would include instructions and a click option to accept
that it has been read. Can anyone help?

I'm sure I have seen this done, but can't find how to make it happen in one
of my files.
--
Mark