ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Automatically Enabling Macros (https://www.excelbanter.com/excel-programming/278876-automatically-enabling-macros.html)

John T Ingato

Automatically Enabling Macros
 
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

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.






All times are GMT +1. The time now is 01:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com