How to get rid of macro warning without disabling message?
Posted by Rohan on October 13, 2001 4:10 AM
Deleted the module--saved--recreated the module empty--saved--still seeing the message--under Tools->Macros there are NO macros listed--any other hints?
How do I get rid of this warning if I have deleted all macros in the ss?
Used to have a macro--no longer do--but can't seem to get the warning message to go away on opening of the sheet.
Thanks.
Posted by Paul on October 13, 2001 5:30 AM
You could use this add in from http://www.asap-utilities.com/ then ASAP utilities, system, remove all macros/VBA code from current file, this does what it says it will remove ALL code form the current file, then just save the workbook. Next time you open it you want get the message
Posted by Jonathan on October 13, 2001 10:47 AM
You say you recreated the module empty, etc. That is why you still get the message. As long as a module exists you will get the message. If you have no macros in the module - the module is truly empty - just remove (delete) the module; it's not needed if there's nothing in it.
HTH
