ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro Security? (https://www.excelbanter.com/excel-discussion-misc-queries/71150-macro-security.html)

bill

Macro Security?
 
Hi,

I have Office 2003 Excel.

I have several macros, mostly .XLM sheets from previous work.
How can I allow these to run without lowering security levels to low?

These are macros I have written--so they do not have a signed certificate.

Help says something about macros "installed in a trusted location" but I
have been unable to find out more about that. How do I create a trusted
location or mark my .XLM locations as trusted?

Any help appreciated.

Thanks,

Bill

bigwheel

Macro Security?
 
You can create your own digital certificate and use it to "sign" your macros.
In the one of the Office folders is Selfcert.exe.

"bill" wrote:

Hi,

I have Office 2003 Excel.

I have several macros, mostly .XLM sheets from previous work.
How can I allow these to run without lowering security levels to low?

These are macros I have written--so they do not have a signed certificate.

Help says something about macros "installed in a trusted location" but I
have been unable to find out more about that. How do I create a trusted
location or mark my .XLM locations as trusted?

Any help appreciated.

Thanks,

Bill



All times are GMT +1. The time now is 08:54 PM.

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