PC Review


Reply
Thread Tools Rate Thread

how do i delete a macro

 
 
Will Fleenor
Guest
Posts: n/a
 
      9th Jan 2007
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 With Quote
 
 
 
 
Chip Pearson
Guest
Posts: n/a
 
      9th Jan 2007
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 With Quote
 
Don Guillett
Guest
Posts: n/a
 
      9th Jan 2007
right click>remove>no

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Will Fleenor" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting a “Delete Column” Macro to a “Delete Row” Macro cardan Microsoft Excel Programming 7 15th May 2010 06:38 PM
Macro to delete current row AND delete objects also located in thatrow. Tonso Microsoft Excel Discussion 3 27th Jan 2009 02:43 PM
Re: Macro to delete sheets and saves remaining file does not properly delete module gazornenplat Microsoft Excel Programming 0 22nd Jun 2005 01:12 AM
Macro to delete sheets and saves remaining file does not properly delete module pherrero Microsoft Excel Programming 7 21st Jun 2005 05:16 PM
macro to delete entire rows when column A is blank ...a quick macro vikram Microsoft Excel Programming 4 3rd May 2004 08:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:09 PM.