ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using my macros in 2007 (https://www.excelbanter.com/excel-programming/381984-using-my-macros-2007-a.html)

Michelle

Using my macros in 2007
 
Hello, I am just switching to using 2007 (beta2), and it is quite a
struggle. One thing that I can't seem to do is to find a setting where I can
run my own macros without completely switching off all macro protection. Is
there a setting tht will allow me to choose whther a macro is safe of not?

Also, can anyone tell me in very simple terms, how I digitally sign my
macros - where do I get a digital certificate/signature? Can I get a free
one? How do I use it once I've got it?

Many thanks




Jon Peltier

Using my macros in 2007
 
What used to be called the "Medium" security level has been changed to
"Disable all macros with notification". Much clearer, isn't it? Practically
self-explanatory.

Go to the Office menu, Excel Settings button, Trust Center, Trust Center
Settings button, then select the "Disable all macros with notification"
option.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Michelle" wrote in message
...
Hello, I am just switching to using 2007 (beta2), and it is quite a
struggle. One thing that I can't seem to do is to find a setting where I
can run my own macros without completely switching off all macro
protection. Is there a setting tht will allow me to choose whther a macro
is safe of not?

Also, can anyone tell me in very simple terms, how I digitally sign my
macros - where do I get a digital certificate/signature? Can I get a free
one? How do I use it once I've got it?

Many thanks







All times are GMT +1. The time now is 10:04 AM.

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