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
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