Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default 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



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,582
Default 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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Macros in 2007 JLara-MSN-WI Excel Discussion (Misc queries) 6 May 31st 09 03:12 PM
Macros in 2007 Winnipeg Michael Excel Discussion (Misc queries) 13 September 9th 08 06:44 PM
Excel 2007 macros - how to merge 5 macros together into one Sue Excel Discussion (Misc queries) 1 April 16th 08 08:36 PM
Enable macros in 2007 Anita Excel Discussion (Misc queries) 5 February 10th 07 04:24 PM
macros 2007 Rich Mcc Excel Programming 2 May 29th 06 12:59 PM


All times are GMT +1. The time now is 12:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"