Forum Discussion

BTNG's avatar
BTNG
Copper Contributor
Oct 29, 2019
Solved

Cannot edit a Macro on a hidden workbook

-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

  • Smitty Smith's avatar
    Smitty Smith
    Iron Contributor

    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.

Resources