close

The warning keeps popping up about macros when i open some files i
created. None of them have macros anymore. What is going on?

Thanks for your help!--
Chuck N
------------------------------------------------------------------------
Chuck N's Profile: www.excelforum.com/member.php...oamp;userid=27057
View this thread: www.excelforum.com/showthread...hreadid=522795Debra Dalgleish shows how to clean up all the remnants of macros:
www.contextures.com/xlfaqMac.html#NoMacros

Chuck N wrote:
gt;
gt; The warning keeps popping up about macros when i open some files i
gt; created. None of them have macros anymore. What is going on?
gt;
gt; Thanks for your help!
gt;
gt; --
gt; Chuck N
gt; ------------------------------------------------------------------------
gt; Chuck N's Profile: www.excelforum.com/member.php...oamp;userid=27057
gt; View this thread: www.excelforum.com/showthread...hreadid=522795

--

Dave Peterson


sweet, i love finding my own answers. So I guess even after you delete
the macro from excel, it still thinks its there. So what I did was I
went to the VB Editor by pressing Alt F11, pressed Control R to get
the menu on the left and delete my code that was still there on the
sheet. Then I pressed the sign next to Module, right clicked, and
deleted the module. I guess this is like the skelaton of the Macro
that Excel thinks is a Macro. After that I closed the windows, saved,
and whallla, no more pesky windows about Macros --
Chuck N
------------------------------------------------------------------------
Chuck N's Profile: www.excelforum.com/member.php...oamp;userid=27057
View this thread: www.excelforum.com/showthread...hreadid=522795

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()