Hi Developers Im trying to edit Ron de Bruin's macro (but i cant seem to get to macro open specified worksheets (named worksheet with format xlsm), copy data from from two tabs and then paste into tab called 'OverzichtInhoud, which is in the active workbook. Ive tried different combinations but nothing is working. I guess here is where i have to call in the profs for help.
The first Microsoft that shows up for the Personal Macro Workbook in OSX erroneously lists the location of the workbook as: Hard disk drive:Applications:Microsoft Office version:Office:Startup:Excel:Personal Macro Workbook In OSX Yosemite (10.10), the location of the Personal Macro Workbook is different. Starting at /home/ or /Users/$username: `/Library/Application Support/Microsoft/Office/Excel/Personal Macro Workbook.xlsb` The easiest way to create this is to record a dummy macro.
![Mac Mac](/uploads/1/2/5/4/125405825/192309058.png)
The solution regarding deleting the macro workbook worked for me, but the instructions need to be adapted for the Mac (the poster is referring to Windows, but the OP asked about Excel 2011, which is a product for the Mac). The file path containing the personal macros workbook on the Mac is.