Click here to join today If youre new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

For a better experience, please enable JavaScript in your browser before proceeding.

How can I delete them Tools Macro brings up a list of macros, but among the action choices offered, the Delete button is grayed out.

Right click. Select remove module when asked whether you want to export the module select NO.

I have macros in personal.xls but the Delete option isnt greyed out for me.

Vba Editor Greyed Out In Excel Full Delete Is

That youll need to remove the macro module(s) to do a full delete is a given though.

In Excel, although not in VBA, I can see a list of macros by clicking Tools Macro.

But double-clicking one that I want to delete produces an error message saying Reference is not valid.

Your instructions are for Excel 2007, but my version is Excel 2002 SP3, which may respond differently.

Previous versions of Excel stored their macros in macro sheets.

Where should I look for a hidden macro sheet Im using Excel 2002 SP3 on Windows XP.

Vba Editor Greyed Out In Excel Code And I

It should be a sheet that contains the macro code and I think its hidden.

If you cannot find anything in a vba project then I dont know.

You could try and save the workbook as a csv file and then reopoen it, the macros will be gone, but do keep in mind that formatting will be gone too and you will have to save a separate files for each sheet.

Dont forget to use the button Mark Solved if this is the case.

This site is completely free -- paid for by advertisers and donations.

Advertisements do not imply our endorsement of that product or service.

By continuing to use this site, you are consenting to our use of cookies.

Vba Editor Greyed Out In Excel For Mac