Thread: Opening a workbook at a specific sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Opening a workbook at a specific sheet
Hi Nirmal

get rid of this prompt?
The only simple way is that the user have security to low

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Nirmal Singh" wrote in message ...
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


Reply With QuoteReply With Quote