Running Excel 2003 on Windows XP.

It seems that once a macro is in a worksheet, I always get the "this
spreadhseet has macros, do you want to enable them" message for that
worksheet, even if I have deleted them. It seems like once you trip the
macros switch, I don't know how to go back and shut it off so I don't get
that warning anymore.

I don't want to stop that warning on spreadsheets where there are macros,
but how do I get it turned off on spreadsheets that once had macros, but no
longer have any? Thanks,

Joe

See if this helps:

http://contextures.com/xlfaqMac.html#NoMacros

--
Biff
Microsoft Excel MVP


"Joe M" <(E-Mail Removed)> wrote in message
news:4FE6A87E-4741-4E1E-8CD1-(E-Mail Removed)...
> Running Excel 2003 on Windows XP.
>
> It seems that once a macro is in a worksheet, I always get the "this
> spreadhseet has macros, do you want to enable them" message for that
> worksheet, even if I have deleted them. It seems like once you trip the
> macros switch, I don't know how to go back and shut it off so I don't get
> that warning anymore.
>
> I don't want to stop that warning on spreadsheets where there are macros,
> but how do I get it turned off on spreadsheets that once had macros, but
> no
> longer have any? Thanks,
>
> Joe