View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Allison Allison is offline
external usenet poster
 
Posts: 40
Default Macro warning when no macros

Thanks Frank for the pointer. This information worked perfectly!

Allison

"Frank Kabel" wrote:

Hi
also delete the empty modules and check the workbook / worksheet
modules. See:
http://www.contextures.com/xlfaqMac.html#NoMacros

--
Regards
Frank Kabel
Frankfurt, Germany

"Allison" schrieb im Newsbeitrag
...
Excel XP, Windows 2000

I have a worksheet that formerly had recorded macros (not VBA) in it.

I deleted all the macros (none show up in Tools/Macro.../Macros),

then saved
and closed the file.

When I come back in, I still get the warning about macros in the

file.

Any ideas on how to really clean out the macros so that warning no

longer
appears? (Interestingly, I had some VBA code in another file and

deleted the
VBA - no warning.)

Thanks for any suggestions.

Allison