Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening Files to Dailogue Box
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening files in folders and subfolders | Excel Discussion (Misc queries) | |||
Issue opening csv files in Excel | Excel Discussion (Misc queries) | |||
Opening multiple Excel files that contain varied selected sheets | Excel Worksheet Functions | |||
Automatically opening several Excel Files at startup | Excel Discussion (Misc queries) | |||
opening excel files with links to other data sources | Excel Discussion (Misc queries) |