Auto Start Macro in Excel
I would like to know how to create a Macro in Excel (Maybe something better),
that would automatically go to "Sheet1" Cell A5 at the launch of Excel. Currently I have Sub Auto_Activate() Sheets("Sheet1").Select Range("A5").Select End Sub which is not working. When I leave, saving the file and launch again it brings me back to the Sheet I was on at last save. Thanks in advance! |
Auto Start Macro in Excel
You can use the macro you wrote except name it:
Sub Auto_Open That macro will not fire if the file is opened by code. In that case use a Workbook_Open event macro. Note that a Workbook_Open event macro must be placed in the workbook module. Post back if you need more. HTH Otto "ABC Seamless Wayne" wrote in message ... I would like to know how to create a Macro in Excel (Maybe something better), that would automatically go to "Sheet1" Cell A5 at the launch of Excel. Currently I have Sub Auto_Activate() Sheets("Sheet1").Select Range("A5").Select End Sub which is not working. When I leave, saving the file and launch again it brings me back to the Sheet I was on at last save. Thanks in advance! |
Auto Start Macro in Excel
Thank you very much. Auto_Open works just fine.
"Otto Moehrbach" wrote: You can use the macro you wrote except name it: Sub Auto_Open That macro will not fire if the file is opened by code. In that case use a Workbook_Open event macro. Note that a Workbook_Open event macro must be placed in the workbook module. Post back if you need more. HTH Otto "ABC Seamless Wayne" wrote in message ... I would like to know how to create a Macro in Excel (Maybe something better), that would automatically go to "Sheet1" Cell A5 at the launch of Excel. Currently I have Sub Auto_Activate() Sheets("Sheet1").Select Range("A5").Select End Sub which is not working. When I leave, saving the file and launch again it brings me back to the Sheet I was on at last save. Thanks in advance! |
All times are GMT +1. The time now is 06:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com