Forum Discussion
Excel for Mac - Lost my Personal Macro Workbook
emhorton To my knowledge, you must NOT save your macros in the Personal Macro Workbook. I have actually never done that as I rarely write macros that I must use in multiple workbooks over and over again. But that's just my way of perhaps not using macros correctly.
Try navigating to this location on your Mac
Do you find Personal.xlsb there?
- I appreciate the response! I found the Library but cannot find a Containers folder within in. As mentioned before, I'm not a huge computer wiz.
I have also searched my hard drive for personal.xlsb and nothing pulls up.emhorton Difficult to help you without access to your Mac. But do you really need to the Personal workbook? What if you just record a macro in "This Workbook"?
Riny_van_Eekelen I tried saving it in "All Open Workbooks" but then it's not accessible to other workbooks. Also I cannot copy and paste the data I need into the workbook because it's a very large amount of data. I need the Macro to be available across any workbook.
