Macro warning when no macros
 

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

Macro warning when no macros
 

Make sure you delete all the names that may still be lingering. Go to the
insert menu, select name, then define. If there are any names remaining
you'll be able to delete them there.
Eloy

"Allison" wrote:

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

Macro warning when no macros
 

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

Macro warning when no macros
 

Thanks Eloy, but that wasn't the culprit (no names are there). Any other
suggestions?

Allison

"Eloy" wrote:

Make sure you delete all the names that may still be lingering. Go to the
insert menu, select name, then define. If there are any names remaining
you'll be able to delete them there.
Eloy

"Allison" wrote:

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

Macro warning when no macros
 

Allison

You have left-over empty module(s) you must get rid of.

See Debra Dalgleish's site for info on this.

Gord Dibben Excel MVP

On Fri, 22 Oct 2004 14:23:07 -0700, "Allison"
wrote:

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

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

Macro warning when no macros
 

Thanks Gord. I got the URL from Frank's post and it works perfectly!

Allison

"Gord Dibben" wrote:

Allison

You have left-over empty module(s) you must get rid of.

See Debra Dalgleish's site for info on this.

Gord Dibben Excel MVP

On Fri, 22 Oct 2004 14:23:07 -0700, "Allison"
wrote:

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

Macro warning when no macros
 

The procedures described are for VBA macros. I thought you said they were
not VBA macros?

--
Regards,
Tom Ogilvy


"Allison" wrote in message
...
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

Macro warning when no macros
 

What! No URL in my post.

So strange. How could I have forgotten that<g

Gord Dibben Excel MVP

On Fri, 22 Oct 2004 15:03:01 -0700, "Allison"
wrote:

Thanks Gord. I got the URL from Frank's post and it works perfectly!

Allison

"Gord Dibben" wrote:

Allison

You have left-over empty module(s) you must get rid of.

See Debra Dalgleish's site for info on this.

Gord Dibben Excel MVP

On Fri, 22 Oct 2004 14:23:07 -0700, "Allison"
wrote:

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