![]() |
Automating application error responses
I there a way to have the workbook automaticlly respond to the 'Enable Macro'
error message at startup, I get tired of clicking it and when I digitlly sign the workbook it tells me that I am not a trusted macro publisher. I thought I might be able to circumvent the application and make it answer its own question. |
Automating application error responses
No, that is intended to block viruses for inadvertedly opening a file that
will run a malicious code. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Mekinnik" wrote: I there a way to have the workbook automaticlly respond to the 'Enable Macro' error message at startup, I get tired of clicking it and when I digitlly sign the workbook it tells me that I am not a trusted macro publisher. I thought I might be able to circumvent the application and make it answer its own question. |
Automating application error responses
Not recommended, but it is possible.
You can go to Tools--Options--Security and click the Macro Security button. Then set it to Low. That will cause the Enable Macros message to not display at all. Mekinnik wrote: I there a way to have the workbook automaticlly respond to the 'Enable Macro' error message at startup, I get tired of clicking it and when I digitlly sign the workbook it tells me that I am not a trusted macro publisher. I thought I might be able to circumvent the application and make it answer its own question. |
All times are GMT +1. The time now is 12:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com