VBA code to open a specific worksheet
Does anyone know the code to open a specific worksheet within a workbook
when you first open the workbook? I have a main input page within the workbook and would like this to be the worksheet that opens or is viewable when i first open the workbook regardless of where i save my work. Many thanks Mark ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
VBA code to open a specific worksheet
Mark,
In a regular module: Sub Auto_Open() Worksheets("yoursheetname").Activate End Sub or you can user the Workbook_Open Event John MohK wrote: Does anyone know the code to open a specific worksheet within a workbook when you first open the workbook? I have a main input page within the workbook and would like this to be the worksheet that opens or is viewable when i first open the workbook regardless of where i save my work. Many thanks Mark ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
VBA code to open a specific worksheet
Here's a post from earlier this week that provides a few answers.
http://www.google.com/groups?hl=en&l...d12011d&rnum=1 HTH Paul -------------------------------------------------------------------------------------------------------------- Be advised to back up your WorkBook before attempting to make changes. -------------------------------------------------------------------------------------------------------------- Does anyone know the code to open a specific worksheet within a workbook when you first open the workbook? I have a main input page within the workbook and would like this to be the worksheet that opens or is viewable when i first open the workbook regardless of where i save my work. Many thanks Mark |
All times are GMT +1. The time now is 10:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com