ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   macro security settings (https://www.excelbanter.com/excel-discussion-misc-queries/175827-macro-security-settings.html)

nsr_rick

macro security settings
 
Excel macro security keeps resetting to high, not allowing self written
macros to run.

How can I get my own macros to run?

I can manually change the setting to low each time I open excel, however
some of my macros auto print documents on a daily basis, with no user
present. These won't print as the macro setting is reset to high.

I have searched the issue on the web and have found others with the issue,
but none with the solution.

Thanks,

Rick



Gord Dibben

macro security settings
 
For use on your own computer you could create a digital certificate using the MS
Office SelfCert Tool.

See Excel Help on digital certificates


Gord Dibben MS Excel MVP

On Wed, 6 Feb 2008 14:30:02 -0800, nsr_rick
wrote:

Excel macro security keeps resetting to high, not allowing self written
macros to run.

How can I get my own macros to run?

I can manually change the setting to low each time I open excel, however
some of my macros auto print documents on a daily basis, with no user
present. These won't print as the macro setting is reset to high.

I have searched the issue on the web and have found others with the issue,
but none with the solution.

Thanks,

Rick




All times are GMT +1. The time now is 09:32 AM.

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