Automatically Enabling Macros

[John T Ingato]

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.

 

[Tom Ogilvy]

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.