Starting MS Excel with a worksheet other than SHEET 1
I have renamed several worksheets in my MS Excel workbook. I want Excel to
start with a particular sheet, but it always start with the same one (supposed to be SHEET 1). How can I start MS Excel with a designated worksheet? Thanks, ICG |
Do you mean that you want a specific file to always open on a specific
sheet? By default, the file will always open on the sheet that was the active sheet when the file was last saved. But you can write a small macro in the workbook module to force a specific sheet to be the active sheet on opening. Something like this: Private Sub Workbook_Open() Sheets("MySheet").Activate End Sub With the file open on the screen, right-click on the Excel icon to the left of the menu item "File" of the menu across the top of the screen. Select View Code. Paste the above macro into the module displayed. Change "MySheet" to the name of the worksheet you want. HTH Otto "IGNACIO" wrote in message ... I have renamed several worksheets in my MS Excel workbook. I want Excel to start with a particular sheet, but it always start with the same one (supposed to be SHEET 1). How can I start MS Excel with a designated worksheet? Thanks, ICG |
in the ThisWorkbook module, workbook_open event use sheets("sheet1").select
-- Don Guillett SalesAid Software "IGNACIO" wrote in message ... I have renamed several worksheets in my MS Excel workbook. I want Excel to start with a particular sheet, but it always start with the same one (supposed to be SHEET 1). How can I start MS Excel with a designated worksheet? Thanks, ICG |
All times are GMT +1. The time now is 03:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com