Macro

[Stan Sitek]

I had a macro in a file which I did not need. Even though
I deleted it, I am still asked whether I want to
enable/disable macros when I open the file. How do I get
rid of all references to the macro to prevent this from
happening?

 

[Carole]

Excel Help has this topic:
Stop checking workbooks for macros that might contain
viruses

1 On the Tools menu, click Options, and then click
the General tab.


2 Clear the Macro virus protection check box.


This will work on all your workbooks - not just this one.

Hope this helps,

Carole

 

[Dave Peterson]

Take a look at Debra Dalgleish's site:

http://www.contextures.com/xlfaqMac.html#NoMacros

Nice pictures. Nice explanation.