Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Todd
 
Posts: n/a
Default macro warning persists even after deleting all macros

I had an old macro in my spreadsheet that I deleted. However, whenever I
open the spreadsheet, I still get the warning saying the spreadsheet contains
macros. When I look at the macros in the spreadsheet, there are none.

Is there a way to stop that warning without adjsuting my security level?

  #2   Report Post  
bj
 
Posts: n/a
Default

delete the module it was in also.

"Todd" wrote:

I had an old macro in my spreadsheet that I deleted. However, whenever I
open the spreadsheet, I still get the warning saying the spreadsheet contains
macros. When I look at the macros in the spreadsheet, there are none.

Is there a way to stop that warning without adjsuting my security level?

  #3   Report Post  
Dave O
 
Posts: n/a
Default

This happens because the module that held the now-deleted code still
exists. Delete the module to avoid the warning.

  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

Debra Dalgleish has nice instructions for getting rid of macros at:
http://www.contextures.com/xlfaqMac.html#NoMacros

Todd wrote:

I had an old macro in my spreadsheet that I deleted. However, whenever I
open the spreadsheet, I still get the warning saying the spreadsheet contains
macros. When I look at the macros in the spreadsheet, there are none.

Is there a way to stop that warning without adjsuting my security level?


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
deleting a macro resulted in a problem militant Excel Discussion (Misc queries) 9 April 29th 05 08:01 PM
deleting a macro resulted in a problem militant Excel Discussion (Misc queries) 0 April 26th 05 05:21 AM
Macro warning (upon opening) Richard Excel Discussion (Misc queries) 4 February 18th 05 10:43 PM
disable macro warning kim Excel Discussion (Misc queries) 2 December 30th 04 05:57 PM
After deleting a macro, I still get the pop-up when opening file Anne Excel Worksheet Functions 2 December 8th 04 05:31 PM


All times are GMT +1. The time now is 08:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"