| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
open workbook to specific sheet
I am trying to force excel to open to the same workesheet each time the work
book is opened. regardless of where it was last saved. Is this possible? If so, how would you accomplish this. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
open workbook to specific sheet
In the 'ThisWorkbook' module, put the following code (adapted to the
worksheet you want)... Private Sub Workbook_Open() Worksheets("Sheet1").Activate End Sub -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Mr E" wrote: I am trying to force excel to open to the same workesheet each time the work book is opened. regardless of where it was last saved. Is this possible? If so, how would you accomplish this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open Workbook on Specific Worksheet | Excel Discussion (Misc queries) | |||
| Using a Windows Shortcut to Open to Specific Sheet in Workbook | Excel Discussion (Misc queries) | |||
| OPEN A WORKBOOK TO A SPECIFIC WORKSHEET | Excel Discussion (Misc queries) | |||
| Open a new workbook with a specific name | Excel Discussion (Misc queries) | |||
| How do I open a workbook in a specific sheet | Excel Discussion (Misc queries) | |||
![Mr E[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
