MrExcel Publishing
Your One Stop for Excel Tips & Solutions

display userform when opening a spreadsheet

Posted by raj nair on January 28, 2002 1:10 PM

I have a spreadsheet navigator userform defined and would like it to pop up each time a user opens the spreadsheet and would also like it to pop up with a keyboard shortcut.

The excel help mentions app_workbookopen(ByVal Wb As Workbook), but I cannot get it to work. Do I need to define the app , where do I define this procedure, etc ..

any help most appreciated.

Posted by Juan Pablo G. on January 28, 2002 1:34 PM

I don't think you need to go THAT deep.

When in VBE, double click on ThisBook module, and select Workbook on the left and Open on the right.

Then, in between you should put something like


The entire thing should look like this

Private Sub Workbook_Open()
End Sub

Juan Pablo G.