Dialog box and opening an excel file

J

jks

Hi,

Im far from an expert user, so il need someones expertise in thi
matter. I suspect its rather easy to solve.

Ive created a dialog box in an excel file. The box contains certai
buttons with simple macros so i can navigate throgh the document.
want to have the dialog box open automaticly when i open the file. Ho
do I do this ???

Please help me!

/JS
Denmar
 
F

Frank Kabel

Hi
one way: you can create a macro name 'Auto_Open()'. This will be
invoked automatically then opening your workbook. Insert your code to
activate your dialog box in this procedure

Frank
 
J

jks

Thx a lot Frank,

Ive tried to figure out the code for opening a dialog and I cant find
it.

Can u help me once again with this matter ?

/JS
Denmark
 
M

Mark Rosenkrantz

JS;

You can load the Userform as follows.
In the VBA Editor doubleclick ThisWorkbook.
In the module window, click the 1st dropdownbutton (General) and choose
Workbook.

A new module occurs where you have to insert just one line of code !!
At the end it looks like this.

Private Sub Workbook_Open()
UserForm1.show
End sub

Mark.

More Excel ? www.rosenkrantz.nl or [email protected]
 
Top