disable macros

[jim b]

I am trying to eliminate the pop-up request to
enable/disable macros by erasing the macro. How do I find
it? How do I erase it?

thanks!

jim b.

 

[Ron de Bruin]

Hi Jim

One option :
You can set your security to Low
Tools>Macro>Security

 

[Kevin M]

Jim,

The most dangerous way to do it is to go into Tools >
Macros > Security and change it from either High or
Medium to Low. ***Remember that this gives you NO
protection from possibly unsafe Macros. Excel will run
them all no matter what.***

HTH
Kevin M

 

[Dennis]

ALT-F8 then select and delete it

if not yet gone....

ALT-F11, View>Project Explorer, Select the module it's in and remove without
exporting it

Dennis
=============

 

[jim b]

I tried ALT-F8 and no macros showed up - so it looks like
I did delete it - however, when I close the file and re-
open it - I still get the pop-up box asking whether I want
to disable or enable the macros.

Any other thoughts?

-----Original Message-----
ALT-F8 then select and delete it

if not yet gone....

ALT-F11, View>Project Explorer, Select the module it's in and remove without
exporting it

Dennis
=============

 

[Ron de Bruin]

Check out this site
http://www.contextures.com/xlfaqMac.html#NoMacros

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)

I tried ALT-F8 and no macros showed up - so it looks like
I did delete it - however, when I close the file and re-
open it - I still get the pop-up box asking whether I want
to disable or enable the macros.

Any other thoughts?

 

[may]

I believe you would go to Tools, Macro, Security and
select the low security level.