Macros

A

Andy

I have saved a macro to my "personal macro workbook" now
when I try to edit or delete these macros the
message "Cannot edit a macro on a hidden workbook. Unhide
the workbook using the unhide command." How can I edit or
delete these macros?
 
B

Bob Umlas, Excel MVP

Like it says, you should unide it -- Windows/Unhide.... OR, you can use alt/F11 to take you to the VBA, and find the macros there and simply delete it/the
----- Andy wrote: ----

I have saved a macro to my "personal macro workbook" now
when I try to edit or delete these macros the
message "Cannot edit a macro on a hidden workbook. Unhide
the workbook using the unhide command." How can I edit or
delete these macros
 
D

DavidP

Select option Window/Unhide which will then reveal the Personal workbook. You can now edit or delete any macros just as you would in any other workbook. Make
sure you hide the workbook once you have made your changes. When you close Excel say "Yes" to saving any changes to the personal workbook

DavidP
 
Top