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.

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.

how do i delete a macro
 

right clickremoveno

--
Don Guillett
SalesAid Software

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