S Saxman Aug 3, 2007 #1 How does one delete a macro in 2007? I checked the help files, but cannot find anything. It's easy in 2003!
How does one delete a macro in 2007? I checked the help files, but cannot find anything. It's easy in 2003!
B Bob Phillips Aug 3, 2007 #2 Go into the VBIDE, Alt-F11, and open the code module and delete it. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
Go into the VBIDE, Alt-F11, and open the code module and delete it. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
B Bob Phillips Aug 3, 2007 #3 Another way is to show the Developer tab(Office button>Excel Options>Popular, and check the 'Show the Developer tab in the ribbon' box). Then goto the Developer tab, click Macros in the Code group, and delete it from there. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
Another way is to show the Developer tab(Office button>Excel Options>Popular, and check the 'Show the Developer tab in the ribbon' box). Then goto the Developer tab, click Macros in the Code group, and delete it from there. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
S Saxman Aug 3, 2007 #4 Sod's Law! Went to Developer/Macros today and there was the delete button! Thanks for all the help.