Apr 15 2019 08:20 AM
I have a coworker who is having a problem with their personal workbook. I tried it on my computer and I'm having the same problem. So, I do not believe it is specific to their computer.
I go through the process of creating a macro and saving to my personal workbook. I exit Excel and go back in and create a new workbook. When I click on Macros, I would expect to see a list of my macros in my personal workbook, but it does not show up. I have to open my "PERSONAL" workbook that contains my macros to use in my other spreadsheet. It didn't always work this way. How can I configure so my personal macros are available whenever I open ANY workbook?
Apr 15 2019 10:56 AM
SolutionApr 15 2019 01:32 PM
Yes, this worked. The key was to check if the PERSONAL file already existed in that directory and move or delete it. Then, open the macro file and hide it. Then save the file to that folder. It took a couple tries to get the sequence correct, but it then worked as I hoped. This made my day. Thanks again!
Apr 15 2019 10:56 AM
Solution