ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Automating application error responses (https://www.excelbanter.com/excel-programming/398898-automating-application-error-responses.html)

Mekinnik

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.

Michael

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.


JW[_2_]

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