| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Disabling Macro Warning
How do I prevent the macro warning from popping up while retaining the medium
or high security level? Is it possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Disabling Macro Warning
Tue, 18 Dec 2007 12:18:03 -0800 from scojerroc
: How do I prevent the macro warning from popping up while retaining the medium or high security level? Is it possible? If macros are digitally signed, the warning won't appear. Instructions have been posted here for digitally signing your own macros, but unfortunately that feature doesn't work for me. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/ |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Disabling Macro Warning
I dont want the macros to run. I want to disable the code entirely.
I'm just tired of hitting the N key every time I open these worksheets. "Stan Brown" wrote: Tue, 18 Dec 2007 12:18:03 -0800 from scojerroc : How do I prevent the macro warning from popping up while retaining the medium or high security level? Is it possible? If macros are digitally signed, the warning won't appear. Instructions have been posted here for digitally signing your own macros, but unfortunately that feature doesn't work for me. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/ |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Disabling Macro Warning
If your security is set to high then you will not get a warning. Macros will
be disabled by default... If you wish to retain your medium setting then there is nothing you can do about the warnings. That is the whole point to the medium setting. -- HTH... Jim Thomlinson "scojerroc" wrote: I dont want the macros to run. I want to disable the code entirely. I'm just tired of hitting the N key every time I open these worksheets. "Stan Brown" wrote: Tue, 18 Dec 2007 12:18:03 -0800 from scojerroc : How do I prevent the macro warning from popping up while retaining the medium or high security level? Is it possible? If macros are digitally signed, the warning won't appear. Instructions have been posted here for digitally signing your own macros, but unfortunately that feature doesn't work for me. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/ |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Disabling Macro Warning
Just get rid of the macros and any modules they reside in.
http://www.contextures.on.ca/xlfaqMac.html#NoMacros Gord Dibben MS Excel MVP On Tue, 18 Dec 2007 13:52:02 -0800, scojerroc wrote: I dont want the macros to run. I want to disable the code entirely. I'm just tired of hitting the N key every time I open these worksheets. "Stan Brown" wrote: Tue, 18 Dec 2007 12:18:03 -0800 from scojerroc : How do I prevent the macro warning from popping up while retaining the medium or high security level? Is it possible? If macros are digitally signed, the warning won't appear. Instructions have been posted here for digitally signing your own macros, but unfortunately that feature doesn't work for me. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/ |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Disabling Macro Warning
Just curious Stan.
Will the SelfCert tool not work for you? What happens when you try? What steps do you take to sign each workbook's VBA Project? Gord Dibben MS Excel MVP On Tue, 18 Dec 2007 16:35:42 -0500, Stan Brown wrote: Tue, 18 Dec 2007 12:18:03 -0800 from scojerroc : How do I prevent the macro warning from popping up while retaining the medium or high security level? Is it possible? If macros are digitally signed, the warning won't appear. Instructions have been posted here for digitally signing your own macros, but unfortunately that feature doesn't work for me. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Disabling Macro Warning
When I set it to high, I get a message telling me that it's been disabled.
I'm trying to avoid any message altogether. "Jim Thomlinson" wrote: If your security is set to high then you will not get a warning. Macros will be disabled by default... If you wish to retain your medium setting then there is nothing you can do about the warnings. That is the whole point to the medium setting. -- HTH... Jim Thomlinson "scojerroc" wrote: I dont want the macros to run. I want to disable the code entirely. I'm just tired of hitting the N key every time I open these worksheets. "Stan Brown" wrote: Tue, 18 Dec 2007 12:18:03 -0800 from scojerroc : How do I prevent the macro warning from popping up while retaining the medium or high security level? Is it possible? If macros are digitally signed, the warning won't appear. Instructions have been posted here for digitally signing your own macros, but unfortunately that feature doesn't work for me. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/ |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Disabling Macro Warning
Unfortunately, the modules are protected (they're not mine), and I'm sent
dozens of these workbooks every day. "Gord Dibben" wrote: Just get rid of the macros and any modules they reside in. http://www.contextures.on.ca/xlfaqMac.html#NoMacros Gord Dibben MS Excel MVP On Tue, 18 Dec 2007 13:52:02 -0800, scojerroc wrote: I dont want the macros to run. I want to disable the code entirely. I'm just tired of hitting the N key every time I open these worksheets. "Stan Brown" wrote: Tue, 18 Dec 2007 12:18:03 -0800 from scojerroc : How do I prevent the macro warning from popping up while retaining the medium or high security level? Is it possible? If macros are digitally signed, the warning won't appear. Instructions have been posted here for digitally signing your own macros, but unfortunately that feature doesn't work for me. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/ |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Disabling Macro Warning
Tue, 18 Dec 2007 14:19:18 -0800 from <Gord Dibben
<gorddibbATshawDOTca: Just curious Stan. Will the SelfCert tool not work for you? What happens when you try? "An error occurred during certificate creation. Selfcert was unable to create your certificate." -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/ |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Disabling Macro Warning
Never run across this.
Do you have Administrator privileges? Although, I tested with my wife's limited user account and was able to create a selfcert digital certificate so it seems being Admin is not an issue. Gord On Tue, 18 Dec 2007 23:18:59 -0500, Stan Brown wrote: Tue, 18 Dec 2007 14:19:18 -0800 from <Gord Dibben <gorddibbATshawDOTca: Just curious Stan. Will the SelfCert tool not work for you? What happens when you try? "An error occurred during certificate creation. Selfcert was unable to create your certificate." |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel hyperlinks - disabling warning messages | Links and Linking in Excel | |||
| Disabling an 'on load' macro | Excel Worksheet Functions | |||
| Macro Warning | New Users to Excel | |||
| Macro warning box | Excel Discussion (Misc queries) | |||
| macro warning | New Users to Excel | |||
Linear Mode
