View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Automatically Enabling Macros

No - the option is always available to the user - if it could be disabled
programmatically, then there would not be much reason to have the option to
begin with. In excel 2000 and later, you can certify you project and if the
user accepts you as a trusted source, then on subsequent openings they will
not get such a query.



--
Regards,
Tom Ogilvy

"John T Ingato" wrote in message
...
I am developing an application for many users.

This may seem like a silly question, but is it possible to avoid the
"EnableMacros" dialog from appearing every time the workbook is loaded.

My application doesnt resemble Excel at all, and I would like to hide the
fact that it is based on Excel.