Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 25
Default how do i delete a macro

Excel 2003 all sps loaded
OS: Windows XP

I can find the modules that are macros in my Excel workbook by loading the
VBA editor. However, I can not find how to delete these modules. There is
not delete option on the Edit menu (which is grayed out) and there is no
delete option in the right mouse click menu.



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default how do i delete a macro

You can delete a module by selecting that module in the Project Window
(CTRL+R) and the on the "File" menu choose "Remove Module1" or whatever your
module is named. You can also right-click on the module in the Project
Window and choose Remove from the popup menu.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Will Fleenor" wrote in message
...
Excel 2003 all sps loaded
OS: Windows XP

I can find the modules that are macros in my Excel workbook by loading the
VBA editor. However, I can not find how to delete these modules. There
is
not delete option on the Edit menu (which is grayed out) and there is no
delete option in the right mouse click menu.





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
Macro to delete sheets and saves remaining file does not properly delete module pherrero Excel Programming 1 June 22nd 05 01:12 AM
Macro to delete sheets and saves remaining file does not properly delete module bhawane Excel Programming 0 June 21st 05 04:54 PM
Macro to delete sheets and saves remaining file does not properly delete module bhawane Excel Programming 0 June 21st 05 04:53 PM
Macro to delete sheets and saves remaining file does not properly delete module bhawane Excel Programming 0 June 21st 05 04:53 PM
Macro to delete sheets and saves remaining file does not properly delete module bhawane Excel Programming 0 June 21st 05 04:53 PM


All times are GMT +1. The time now is 10:37 PM.

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

About Us

"It's about Microsoft Excel"