Disabling Macro Warning
 

How do I prevent the macro warning from popping up while retaining the medium
or high security level? Is it possible?

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/

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/

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/

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/

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.

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/

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/

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/

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."