macro warning persists even after deleting all macros
 

I had an old macro in my spreadsheet that I deleted. However, whenever I
open the spreadsheet, I still get the warning saying the spreadsheet contains
macros. When I look at the macros in the spreadsheet, there are none.

Is there a way to stop that warning without adjsuting my security level?

delete the module it was in also.

"Todd" wrote:

I had an old macro in my spreadsheet that I deleted. However, whenever I
open the spreadsheet, I still get the warning saying the spreadsheet contains
macros. When I look at the macros in the spreadsheet, there are none.

Is there a way to stop that warning without adjsuting my security level?

This happens because the module that held the now-deleted code still
exists. Delete the module to avoid the warning.

Debra Dalgleish has nice instructions for getting rid of macros at:
http://www.contextures.com/xlfaqMac.html#NoMacros

Todd wrote:

I had an old macro in my spreadsheet that I deleted. However, whenever I
open the spreadsheet, I still get the warning saying the spreadsheet contains
macros. When I look at the macros in the spreadsheet, there are none.

Is there a way to stop that warning without adjsuting my security level?

--

Dave Peterson