SOLVED

Cannot edit a Macro on a hidden workbook

Copper Contributor

-I am using windows excel but on MBP with parallel.

-I would like to delete unwanted macros.

-"Cannot edit a macro on a hidden workbook." message has been shown.

-I can see the macro is stored in a file called "PERSONAL. XLSB"

-However, I couldn't find out the file

1 Reply
best response confirmed by BTNG (Copper Contributor)
Solution

@BTNG That's your Personal Macro workbook. If you don't see it listed in the VBE, then search your PC for XLSTART, which is the folder it's stored in. You should be able to open it from there.

1 best response

Accepted Solutions
best response confirmed by BTNG (Copper Contributor)
Solution

@BTNG That's your Personal Macro workbook. If you don't see it listed in the VBE, then search your PC for XLSTART, which is the folder it's stored in. You should be able to open it from there.

View solution in original post