Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a workbook at a specific sheet
I have a workbook with various worksheets in it. To force Excel to
open it at a a specific sheet I use code like this in the Workbook Open event: Sheets("MySheet").Activate This works, but the users get prompted to accept Macros. Can I get rid of this prompt? Nirmal |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code for opening a workbook at a specific time!?! | Excel Discussion (Misc queries) | |||
only the last sheet tab appears when opening workbook | Excel Discussion (Misc queries) | |||
Opening a workbook to a chosen sheet? | Excel Discussion (Misc queries) | |||
Opening A Specific Excel Sheet | Excel Discussion (Misc queries) | |||
Excel VBA - Opening a workbook to a specific sheet every time | Excel Programming |