Hello,
I am just about to start a macro project. I would like the macro to be stored in my personal macro workbook so I can run it on any workbook. When I have a workbook open I can select "Record New Macro" and under the "store macro in" dropdown box I can select "Personal Macro Workbook", when I click on "OK" a popup box appears saying, "Peronal macro workbook in the startup folder must stay open for recording", when I click on "OK" another popup box appears saying "unable to record". I'm not sure what to do to check the personal macro workbook is in the correct place or configured correctly such that I can record to it. Thanks for any help to get me going.
Bookmarks