![]() ![]() Now, you'll have the Personal Macro Workbook available to you anytime you use excel. To save, exit excel and choose to save changes: Now, you'll see the Personal Macro Workbook Module in the Visual Basic Editor's Project Pane: Once you click OK, click the record button again to stop recording: Now, hit the record button and choose to store the macro in Personal Macro Workbook: Once this is enabled, you'll see the Developer Tab on the ribbon: In excel, you first need to ensure the Developer tab is enabled by going to Excel → Preferences → Sharing and Privacy → Ribbon → Customize and in the Show or Hide Tabs area, make sure the Developer checkbox is checked: ![]() The easiest way to create this is to record a dummy macro. Starting at /home/ or /Users/$username: `~/Library/Application Support/Microsoft/Office/Excel/Personal Macro Workbook.xlsb` In OSX Yosemite (10.10), the location of the Personal Macro Workbook is different. The first Microsoft KB 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 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |