View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nirmal Singh Nirmal Singh is offline
external usenet poster
 
Posts: 17
Default 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