disable macro warning
 

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?

"Jason Morin" wrote:

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

-----Original Message-----
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?
.

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

--
Regards
Frank Kabel
Frankfurt, Germany

kim wrote:
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?

"Jason Morin" wrote:

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

-----Original Message-----
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?
.

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


kim wrote:
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?

"Jason Morin" wrote:


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


-----Original Message-----
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?
.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html