| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro warning despite no macros in document | Excel Discussion (Misc queries) | |||
| Unwanted Macro Warning for workbook containing no macros | Excel Discussion (Misc queries) | |||
| Macro warning even though macros have been removed. | Excel Discussion (Misc queries) | |||
| macro warning - but no macros | Excel Discussion (Misc queries) | |||
| Macro warning when no macros in workbook | Excel Programming | |||
Hybrid Mode
