6
1
I want all of the macros that I've written to always be available when I'm using Microsoft Excel 2010. How can I do this?
6
1
I want all of the macros that I've written to always be available when I'm using Microsoft Excel 2010. How can I do this?
7
In excel 2010, the personal macro workbook is located at C:\Users\UserName\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.xlsb
. The best way to create this is to record a macro into your personal macro workbook. You do this by:
File - Options - Customize Ribbon
and checking developer
on the right side of the screen record macro
Store Macro In
your Personal Macro Workbook
Stop Recording
macro save
You will now have a personal macro workbook that is visible anytime you open excel. If you have macros stored in other workbooks you can transfer them to the personal macro workbook by moving the modules within Visual Basic
in excel. Additionally, if you have a workbook with a lot of macros, you can navigate to the file location and rename that workbook to PERSONAL and save it as .xlsb
4
I know you've answered your own question here, and it is helpful, but for people wanting to transfer an old personal macro workbook from an Excel 2007 and below, to Excel 2010, they should copy
%APPDATA%\Microsoft\Excel\XLSTART\PERSONAL.XLS
to the same location on the new machine, without renaming it XLSB. Depending on the version of windows, %APPDATA% will point to different locations, so they should use the windows variable when typing their pathname on both machines.
As you said, the directory XLSTART won't exist until a personal macro workbook is created, but manually creating it won't hurt, so long as they restart Excel.
This is true, the
.xlsb
file-type didn't exist until 2007. – Raystafarian – 2014-03-26T14:26:48.473