I"ve to be trying to record a macro in my personal workbook yet i keep acquiring this error. "personal macro workbook in the startup folder should stay open up for recording."

What am i doing wrong?

You are watching: Personal macro workbook in the startup folder must stay open for recording


You could have closeup of the door it throughout a vault macro operation.

In any type of case, you have the right to go to: C:\Users\yourusername\AppData\Roaming\Microsoft\Excel\XLSTART and find spreadsheet PERSONAL.XLSB, and open that, to remove the message.

When you carry out that, and also you next shot to usage the "Macros" features, you can get the error: "Cannot edit a macro ~ above a covert workbook. Unhide the workbook using the Unhide command." the unhide command is under the "View" ribbon, "Window" panel.

That PERSONAL.XLSB spreadsheet stays open for friend to save macros in "Personal Macro Workbook," therefore they"ll be available in any kind of spreadsheet.


Is your macro trying come close something? What actions are you trying come record? Also, have you tried recording the macro come the open workbook rather than the an individual one? it is easy to relocate later.


Thanks for contributing response to at sight User!

Please be certain to answer the question. Administer details and share her research!

But avoid

Asking because that help, clarification, or responding to various other answers.Making statements based upon opinion; back them up with references or personal experience.

To learn more, see our tips on writing good answers.

write-up Your prize Discard

By clicking “Post her Answer”, you agree come our terms of service, privacy policy and also cookie policy

Not the answer you're spring for? Browse other questions tagged windows-7 or questioning your very own question.


site architecture / logo design © 2021 stack Exchange Inc; user contributions licensed under cc by-sa. Rev2021.9.24.40305

See more: 4 Oz Of Water Is How Many Cups, How Many Cups Of Water In 4 Ounces

Super User works best with JavaScript enabled

your privacy

By click “Accept every cookies”, you agree ridge Exchange have the right to store cookie on your maker and disclose info in accordance v our Cookie Policy.