![]() |
Open to tab
The simplest way is to save it with the sheet you want selected but if that
isn't practicable then try:- Private Sub Workbook_Open() Worksheets("Sheet1").Select End Sub with sheet1 changed to the sheet name you want. Mike "Pietro" wrote: Hi , I have an Excel sheet with many tabs.. What should i do to oblige MS Excel to open a certain tab whenever i open this MS excel sheet ? Thanx for your help |
All times are GMT +1. The time now is 02:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com