Event: open workbook

[Guest]

Hi,

I want to run a macro when the workbook is opened.
I am assuming that there is an "Open workbook" event and you can insert some
code there. Does anyone know how to do this? I just want to go to a certain
"tab"/worksheet? when the user opens the workbook.

Thanks for your help!

 

[Paul B]

Jeff, something like this,

Private Sub Workbook_Open()
Sheets("Sheet1").Select
End Sub

To put in this macro, from your workbook right-click the workbook's icon and
pick View Code. This icon is at the top-left of the spreadsheet this will
open the VBA editor to the thisworkbook module, then, paste the code in the
window that opens on the right hand side, press Alt and Q to close this
window and go back to your workbook, now this will run every time you open
the workbook. If you are using excel 2000 or newer you may have to change
the macro security settings to get the macro to run. To change the security
settings go to tools, macro, security, security level and set it to medium
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003