Auto run Macro 2002
Hi
I need a spreadsheet to opne on the same sheet whenever it is opened. I use to be able create a macro and name it Auto_run and it would automatically run when the spreadsheet is opened but this Auto_run does not work in 2002 version of excel. Have they cahnged the naming or is there amother simpler way to get it to do what I want. All help is much appreciated. Cheers PJ |
Auto run Macro 2002
Hi,
Use the inbuilt workbook_open event to select the sheet you want. Alt+F11 to open editor. Doubleclick thisworkbook and paste this in:- Private Sub Workbook_Open() Sheets("MySheet").Select End Sub Mike "PJ" wrote: Hi I need a spreadsheet to opne on the same sheet whenever it is opened. I use to be able create a macro and name it Auto_run and it would automatically run when the spreadsheet is opened but this Auto_run does not work in 2002 version of excel. Have they cahnged the naming or is there amother simpler way to get it to do what I want. All help is much appreciated. Cheers PJ |
Auto run Macro 2002
By the way, the sub you're thinking of is Auto_open, not Auto_run
"Mike H" wrote in message ... Hi, Use the inbuilt workbook_open event to select the sheet you want. Alt+F11 to open editor. Doubleclick thisworkbook and paste this in:- Private Sub Workbook_Open() Sheets("MySheet").Select End Sub Mike "PJ" wrote: Hi I need a spreadsheet to opne on the same sheet whenever it is opened. I use to be able create a macro and name it Auto_run and it would automatically run when the spreadsheet is opened but this Auto_run does not work in 2002 version of excel. Have they cahnged the naming or is there amother simpler way to get it to do what I want. All help is much appreciated. Cheers PJ |
All times are GMT +1. The time now is 08:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com