Delete Macro from personal.xls .. cannot find

**dannac** · 02-12-2007, 04:59 PM

Would like to delete a macro form personal.xls.
It shows in VBE, but when I try to delete, it tells me I must unhide it.

I changed my folder options to show hidden files, and did a search but cannot find it. I have no files in my Office\XLStart folders either.

Advice ??

Thanks
Danna

**Paul** · 02-12-2007, 05:17 PM

To delete the macro, you have to be in Microsoft Excel.

From the menu, choose Window--> Unhide...

You should see "Personal.xls" listed. Select it and click OK.

Once it's opened, go to Tools--> Macro--> Macros...

From there you can delete that macro, then save and close personal.xls.