Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6932
  • Last Modified:

Where are Excel 2011 macros stored on Mac OS X (10.6.6)?

Where are Excel 2011 macros stored on Mac OS X (10.6.6)?  Is it a personal.xlsb file as it is in Windows?  I have a bunch of macros on my Windows computer I would like to use on my Mac.  Can I just copy the file to wherever the folder location is on my Mac?
0
RayWilliams1964
Asked:
RayWilliams1964
  • 3
  • 2
1 Solution
 
jppintoCommented:
Please check this MS article about this:

http://support.microsoft.com/kb/288117

jppinto
0
 
RayWilliams1964Author Commented:
I had followed instructions similar to that by creating a macro and saving it in the personal macros workbook.  Then, I checked the /Applications/Microsoft Office 2011/Office/Startup folder (with hidden files VISIBLE in Finder) but the personal workbook does not show up there.  I know the personal macros workbook exists because when I quit and restart Excel it still shows I have the "dummy" macro saved in it.  Any other ideas?
0
 
RayWilliams1964Author Commented:
I found it!  I searched for "Personal Macro Workbook" in Spotlight because that is the way the Excel VBA Editor shows it named.  It is located in /Documents/Microsoft User Data/Excel and named "Personal Macro Workbook.xlsb".
0
 
jppintoCommented:
If you found it, please don't forget to close the question...thanks.

jppinto
0
 
RayWilliams1964Author Commented:
This was it.
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now