disable macro warning

[Rose]

I added macro which I then deleted. Every time I enter
system it asks me if I want to disable or enable macros -
how do I turn off this warning screen upon entering system
when I have no macros in the worksheet?

 

[Jason Morin]

You need to remove the module that contained the macro.
Press ALT+F11, go to View > Project Explorer (if needed),
right-click on the module(s), and remove it. Save.

HTH
Jason
Atlanta, GA

 

[AlfD]

Hi!

Have you any residual (though possibly empty) code modules in th
workbook? If so, delete them.

Al

 

[Rose]

Thanks so much.

 

[Rose]

Thanks so much Atlanta, you fixed my problem.

-----Original Message-----
You need to remove the module that contained the macro.
Press ALT+F11, go to View > Project Explorer (if needed),
right-click on the module(s), and remove it. Save.

HTH
Jason
Atlanta, GA


.

 

[Guest]

I have a similar problem-- there is no macro in my file.


In attempting your solutions-
- It is not letting me "remove" any modules. ("remove" is disabled)
- I cannot delete the residual code.

Any ideas?

 

[Frank Kabel]

Hi
follow these steps:
http://www.contextures.com/xlfaqMac.html#NoMacros

 

[Debra Dalgleish]

If the workbook is shared you won't be able to remove the modules. To
turn off sharing, choose Tools>Share Workbook
On the Editing tab, remove the check mark from 'Allow changes by more
than one user...'
Click OK, then click Yes to confirm.