Save a Macro

schlepers

Board Regular
Joined
Jun 17, 2008
Messages
68
How do you save a macro so that it will appear in any started excel workspace?
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,974
Office Version
  1. 365
Platform
  1. Windows
Save it to your Personal Macro Workbook.

The easiest way to get there is to record a new macro and on the screen where you enter its name, hit the drop-down list under "Store macro in:" and select "Personal Macro Workbook". Then click OK, then stop the macro.

Then when you go into the VB Editor, you should be able to see your Personal Macro Workbook and you can store your code there and it will be available to you whenever you have Excel open on that computer.
 

schlepers

Board Regular
Joined
Jun 17, 2008
Messages
68
Save it to your Personal Macro Workbook.

The easiest way to get there is to record a new macro and on the screen where you enter its name, hit the drop-down list under "Store macro in:" and select "Personal Macro Workbook". Then click OK, then stop the macro.

Then when you go into the VB Editor, you should be able to see your Personal Macro Workbook and you can store your code there and it will be available to you whenever you have Excel open on that computer.

How do I unhide a workbook? I says I have to do that to edit it.

thx.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,974
Office Version
  1. 365
Platform
  1. Windows
How do I unhide a workbook? I says I have to do that to edit it.
At what point are you getting that message?

If they are talking about the Personal Macro Workbook, you really don't need to unhide itm because you aren't editing the worksheet itself, but rather the VBA behind it.

Once you record a macro that you save to the Personal Macro Workbook, you should be able to see the Personal Macro Workbook from the Object Browser in the VB Editor.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,384
Messages
5,601,326
Members
414,443
Latest member
lionking15

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top