Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't delete macro
In Excel 2002 SP3 I would like to delete an old macro that has bee copied through numerous revisions and copies of an old spreadsheet. When I go into Tools, Macro, This Worksheet, and select the macro th "delete" tab is qreyed out and not accessible. How do I delete thi macro -- Lra ----------------------------------------------------------------------- Lram's Profile: http://www.excelforum.com/member.php...info&userid=23 View this thread: http://www.excelforum.com/showthread.php?threadid=38765 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't delete macro
try going into the VBA and actually deleting the code or removing the respective module. -- speyry ------------------------------------------------------------------------ speyry's Profile: http://www.excelforum.com/member.php...o&userid=25128 View this thread: http://www.excelforum.com/showthread...hreadid=387657 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't delete macro
I previously went into VBA and can identify the module. I didn't try t delete the code. I did try to delete the module but couldn't access commmand to do so -- Lra ----------------------------------------------------------------------- Lram's Profile: http://www.excelforum.com/member.php...info&userid=23 View this thread: http://www.excelforum.com/showthread.php?threadid=38765 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't delete macro
In the VBIDE, select the module, then FileRemove Module, and say no when it
asks to export. -- HTH Bob Phillips "Lram" wrote in message ... I previously went into VBA and can identify the module. I didn't try to delete the code. I did try to delete the module but couldn't access a commmand to do so. -- Lram ------------------------------------------------------------------------ Lram's Profile: http://www.excelforum.com/member.php...nfo&userid=238 View this thread: http://www.excelforum.com/showthread...hreadid=387657 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't delete macro
Alt + F11 to get to the VBIDE (the visual basic screen). Ctrl + R to get the
Project Explorer if it is not visible (This is the tree view showing all of the spreadsheets). Then either follow Bob's instruction or right click on the module and select remove. Once again chose No when asked about Exporting. -- HTH... Jim Thomlinson "Bob Phillips" wrote: In the VBIDE, select the module, then FileRemove Module, and say no when it asks to export. -- HTH Bob Phillips "Lram" wrote in message ... I previously went into VBA and can identify the module. I didn't try to delete the code. I did try to delete the module but couldn't access a commmand to do so. -- Lram ------------------------------------------------------------------------ Lram's Profile: http://www.excelforum.com/member.php...nfo&userid=238 View this thread: http://www.excelforum.com/showthread...hreadid=387657 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't delete macro
Thanks to both of you. After the first reply I went looking again and found the command to remove the module, and sucessfully did so. I appreciate the additonal comments as I have learned more about the structure. -- Lram ------------------------------------------------------------------------ Lram's Profile: http://www.excelforum.com/member.php...nfo&userid=238 View this thread: http://www.excelforum.com/showthread...hreadid=387657 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming |