editing a macro

[Ben]

Hello,

When I Go to Developer - Macros and click "edit" on a macro I created
ages ago to modify, it says "Cannot edit a macro on a hidden workbook.
Unhide the workbook using the unhide command." The macro is in
PERSONAL.XLSB and I am using Excel 2007.

Thanks.
Ben

 

[Ben]

Hello,

When I Go to Developer - Macros and click "edit" on a macro I created
ages ago to modify, it says "Cannot edit a macro on a hidden workbook.
Unhide the workbook using the unhide command." The macro is in
PERSONAL.XLSB and I am using Excel 2007.

I think I found the answer over here:
http://www.lytebyte.com/2008/09/09/how-to-unhide-personalxlsb-and-edit-it-in-excel-2007/