Re: Can't delete macro in Excel
It sounds like you may have deleted the macro but left behind a module. Open the spreadsheet, press the keys Alt & F11 together to open the Visual Basic Editor window. On the left hand side under the heading 'Project - VBA Project' you should see a heading called 'VBAProject (zzzzz.xls)' where zzzzz is the name of your spreadsheet. Under that heading should be a folder call 'Modules', and under that is 'Module1'. Right click 'Module1' and remove it (don't export it first). Repeat for other unused modules (if any). Save, close and re-open your spreadsheet.
Andrew
Last edited by andrew93; 21-11-2009 at 11:26 AM.
Reason: typo
|
Threaded Mode
