Can't Unhide or Delete Macro

**flebber** · 07-24-2010, 03:09 AM

I appear to have a little mess in the macro's I want to delete all macros or set "reset" it. I have unused macros which relate to some workbooks which don't exists. I receive an error cannot delete macro please unhide workbook.

I have checked format cells > visibility but the option to unhide worksheet is greyed out. Is there a workaround to this?

**royUK** · 07-24-2010, 04:22 AM

What are you trying to do? Unhiding sheets isn't necessary,I suspect that the macros are in your PERSONAL.xlsm

**flebber** · 07-24-2010, 08:35 PM

I was trying to tidy up the macros as most were just tests when I was trying to get things right. But now I have ebtries in Macro editor I cannot remove.

**flebber** · 07-25-2010, 07:26 PM

No luck the old books in personal.xlsb are still stuck there. If I reinstall Exel will this remove old settings or is there something to delete in locals > application data or similar hidden folder to clean.

**flebber** · 07-25-2010, 08:22 PM

Solved it worked deleting personal and all other macro books from C:\Documents and Settings\Family\Application Data\Microsoft\Excel\XLSTART and restarting resolved issue.