Save Your Excel Macro for Use in All Workbooks

Have you ever lost your macro or decided it is just too useful for only one workbook? You can save your macro in PERSONAL.xlsb to apply the macro to all workbooks that you open and use on your computer. (Macros stored in personal.xlsb will not be available on other computers.)

Save a macro to your Personal Macro Workbook:
1. Click Record Macro on the Developer tab as you normally would.
2. In the Record Macro dialog box, choose Personal Macro Workbook from the Store macro in: dropdown options.
3. Complete the macro as you normally would.
4. When you exit Excel, you will be prompted to save changes made to the Personal Macro Workbook. Click Save.

Unhide Personal Macro Workbook:
If you wish to edit a macro that is saved in the Personal Macro Workbook, you will first need to unhide it.

1. In any open workbook, click Unhide on the View tab.
2. Select PERSONAL from the dialog box.


3. Select and edit macros saved to your Personal Macro Workbook.
4. Save then Hide the workbook when your changes are complete.

Local Seminars Related to this Topic:

Microsoft® Excel®: Beyond the Basics

LIVE ONLINE SEMINARS

Oct. 26

Pacific Time Zone

Oct. 28

Central Time Zone

Nov. 2

Central Time Zone

Nov. 3

Central Time Zone

Nov. 4

Eastern Time Zone

Nov. 5

Central Time Zone

Nov. 9

Central Time Zone

Nov. 10

Eastern Time Zone

Nov. 16

Pacific Time Zone

Nov. 18

Central Time Zone

Nov. 19

Central Time Zone

Nov. 30

Central Time Zone

Dec. 2

Central Time Zone

Dec. 3

Eastern Time Zone

Dec. 7

Central Time Zone

Dec. 8

Central Time Zone

Dec. 9

Eastern Time Zone

Dec. 10

Pacific Time Zone

Dec. 14

Central Time Zone

Dec. 15

Pacific Time Zone

Dec. 16

Eastern Time Zone

Dec. 17

Central Time Zone

Jan. 6

Central Time Zone

Jan. 11

Central Time Zone

Jan. 12

Pacific Time Zone

Jan. 14

Eastern Time Zone

Jan. 19

Eastern Time Zone

Jan. 20

Pacific Time Zone

Jan. 21

Central Time Zone

Jan. 25

Central Time Zone

Jan. 27

Central Time Zone

Jan. 28

Eastern Time Zone

Feb. 1

Central Time Zone

Feb. 3

Central Time Zone

Feb. 4

Eastern Time Zone

Feb. 8

Central Time Zone

Feb. 9

Eastern Time Zone

Feb. 11

Central Time Zone

Feb. 15

Central Time Zone

Feb. 17

Eastern Time Zone

Feb. 17

Central Time Zone

Feb. 23

Central Time Zone

Feb. 25

Pacific Time Zone

Microsoft® Excel® Basics

LIVE ONLINE SEMINARS

Oct. 27

Central Time Zone

Nov. 1

Central Time Zone

Nov. 2

Central Time Zone

Nov. 3

Eastern Time Zone

Nov. 4

Central Time Zone

Nov. 8

Central Time Zone

Nov. 9

Eastern Time Zone

Nov. 15

Pacific Time Zone

Nov. 17

Central Time Zone

Nov. 18

Central Time Zone

Nov. 29

Central Time Zone

Dec. 1

Central Time Zone

Dec. 2

Eastern Time Zone

Dec. 6

Central Time Zone

Dec. 7

Central Time Zone

Dec. 8

Eastern Time Zone

Dec. 9

Pacific Time Zone

Dec. 13

Central Time Zone

Dec. 14

Pacific Time Zone

Dec. 15

Eastern Time Zone

Dec. 16

Central Time Zone

Jan. 5

Central Time Zone

Jan. 10

Central Time Zone

Jan. 11

Pacific Time Zone

Jan. 13

Eastern Time Zone

Jan. 18

Eastern Time Zone

Jan. 19

Pacific Time Zone

Jan. 20

Central Time Zone

Jan. 24

Central Time Zone

Jan. 26

Central Time Zone

Jan. 27

Eastern Time Zone

Jan. 31

Central Time Zone

Feb. 2

Central Time Zone

Feb. 3

Eastern Time Zone

Feb. 7

Central Time Zone

Feb. 8

Eastern Time Zone

Feb. 10

Central Time Zone

Feb. 14

Central Time Zone

Feb. 16

Eastern Time Zone

Feb. 16

Central Time Zone

Feb. 22

Central Time Zone

Feb. 24

Pacific Time Zone

Advanced Microsoft® Excel®-Macros, PivotTables, Charts and More

LIVE ONLINE SEMINARS

Oct. 29

Central Time Zone

Nov. 2

Eastern Time Zone

Nov. 8

Central Time Zone

Nov. 17

Central Time Zone

Nov. 19

Pacific Time Zone

Nov. 29

Central Time Zone

Dec. 3

Central Time Zone

Dec. 8

Central Time Zone

Dec. 9

Central Time Zone

Dec. 14

Eastern Time Zone

Dec. 15

Central Time Zone

Jan. 7

Central Time Zone

Jan. 12

Eastern Time Zone

Jan. 13

Central Time Zone

Jan. 18

Central Time Zone

Jan. 24

Central Time Zone

Jan. 26

Pacific Time Zone

Feb. 2

Eastern Time Zone

Feb. 4

Central Time Zone

Feb. 8

Pacific Time Zone

Feb. 9

Central Time Zone

Feb. 15

Eastern Time Zone

Feb. 18

Central Time Zone

Feb. 24

Central Time Zone

Related Excel® Articles

Categories

Monthly Archives

Leave a Reply

Your email address will not be published. Required fields are marked *