Creating your Personal Workbook

Once your personal workbook is created you can store macros here that will be available to use on all the files you open.

  1. Ensure that you can see the Developer Tab in Excel - it will be in the menu at the top, if you see the Developer Tab jump to step 3 otherwise continue to step

  1. To show the Developer Tab
  1. On the File tab, go to Options > Customize Ribbon.
  2. Under Customize the Ribbon and under Main Tabs, select the Developer check box.
  1. To Create your Personal Macro Workbook
  1. Click the Developer Tab
  2. Click Record Macro
  3. Change the Store macro in location to Personal Macro Workbook
  4. Click OK
  5. Do anything – highlight some cells, type some text, anything. This creates your personal macro workbook.
  6. Click Stop Recording