how do i delete a macro

W

Will Fleenor

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.
 
C

Chip Pearson

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Getting Radio Buttons to work, that are inserted via AutoText 0
Adding custom menus to existing excel application 0
Improving Macro That Keeps First Letter 0
delete module in Excel VBA macro 1
Excel 2003 - VBA to get a list of Module names in the project 4
Cannot display Add-in Macro list without going to VBA/Project 5
CommandBarPopup not recognised as a keyword Excel 2003 3

Top