Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Macro Removal

Fellow Supporties,

Using Excel 97 I've created a simple macro and have since deleted it.
However, when I open the workbook I'm prompted with "enable/disable" macros.
I do not wish to shut off this feature for all workbooks, simply this
particular one. In other words, I want this workbook to appear as if it
never had a macro added. Is there a way to "totally remove" the macros?

Thanks in advance,

David
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 134
Default Macro Removal

hi,
The workbook still has the empty module in it.
open the vb editor (alt+F11)
In the left pane, delete any and all modules in the
workbook. that will stop you enable/disable message.
regards
Frank
-----Original Message-----
Fellow Supporties,

Using Excel 97 I've created a simple macro and have

since deleted it.
However, when I open the workbook I'm prompted

with "enable/disable" macros.
I do not wish to shut off this feature for all workbooks,

simply this
particular one. In other words, I want this workbook to

appear as if it
never had a macro added. Is there a way to "totally

remove" the macros?

Thanks in advance,

David
.

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
Removal of Zero vmohan1978 Excel Worksheet Functions 4 January 24th 10 07:29 AM
Macro removal Mike Milmoe Excel Discussion (Misc queries) 2 February 16th 06 08:19 PM
excel 4.0 macro removal tool Sachin Shah Excel Discussion (Misc queries) 0 August 25th 05 04:17 AM
Sheet removal...help please Terry Excel Discussion (Misc queries) 2 July 19th 05 11:12 PM
Macro Deletion/Removal Pat Davis Excel Programming 1 May 26th 04 03:40 PM


All times are GMT +1. The time now is 03:56 PM.

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"