Why is my Macro not saving in Microsoft 365?

Question

I am new to Macros, and have very little knowledge on the subject.

I am trying to create a macro that will take care of some of the tedious steps that I go through to prepare a file to import into my accounting system.

I have gone through and recorded a macro with the steps that I want automated, and then once I finish I save my file and close my document.

When I go to use my Macro for another file it is no longer there, and I can't find it.

Please advise.

Thanks.

Answer 1

I am new to Macros, and have very little knowledge on the subject.

I am trying to create a macro that will take care of some of the tedious steps that I go through to prepare a file to import into my accounting system.

I have gone through and recorded a macro with the steps that I want automated, and then once I finish I save my file and close my document.

When I go to use my Macro for another file it is no longer there, and I can't find it.

Please advise.

Thanks.

When you set up the macro it appears that you saved it to:-

This Workbook

 - see image below.

To make the macro available to all Workbooks you need to have saved it to the:-

Personal Macro Workbook

Again see image below.

PS if you don’t want to create the macro all over again and at that point save it to:-

Personal Macro Workbook

 - you can copy the macro you’ve already created to:-

Personal Macro Workbook

See:-

Copy a macro module to another workbook - EXCEL for Microsoft 365

Before you invoke the above procedure you’ll have to have both the Workbook in which you created the macro and personal.xlsb open (so that both can be seen in the VBA Project Explorer).