disable macro warning

R

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?
 
J

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
 
A

AlfD

Hi!

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

Al
 
R

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


.
Click to expand...
 
K

kim

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?
 
D

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