ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Macro(s) (https://www.excelbanter.com/excel-discussion-misc-queries/91722-excel-macro-s.html)

bugger

Excel Macro(s)
 
At first I created a Macro in my worksheet and later
deleted it.
Now, everytime I open the worksheet Excel warns
me about Macros.
I know the macro is not there because when I open
the Macro tool it lists no Macros in the worksheet.
Any suggestions??

Thanks



mrice

Excel Macro(s)
 

Maybe you have left one or more empty macro modules in the workbook?


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=547601


Dave Peterson

Excel Macro(s)
 
Debra Dalgleish shows how to clean up all the remnants of macros:
http://www.contextures.com/xlfaqMac.html#NoMacros

bugger wrote:

At first I created a Macro in my worksheet and later
deleted it.
Now, everytime I open the worksheet Excel warns
me about Macros.
I know the macro is not there because when I open
the Macro tool it lists no Macros in the worksheet.
Any suggestions??

Thanks


--

Dave Peterson

bugger

Excel Macro(s)
 
Thanks, Dave, that worked for me.


"Dave Peterson" wrote in message
...
Debra Dalgleish shows how to clean up all the remnants of macros:
http://www.contextures.com/xlfaqMac.html#NoMacros

bugger wrote:

At first I created a Macro in my worksheet and later
deleted it.
Now, everytime I open the worksheet Excel warns
me about Macros.
I know the macro is not there because when I open
the Macro tool it lists no Macros in the worksheet.
Any suggestions??

Thanks


--

Dave Peterson





All times are GMT +1. The time now is 01:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com