Macros don't work if I "Save As" with different name

[Domroy]

I'm sorry, I'm new to writing macros. I'm ok with recording them, but writing is different. I have some macros in a workbook, and if I save it as a different workbook, it won't find the macros when I've assigned them Quick Access Toolbar shortcuts.

I must be missing some code somewhere...thoughts? Do you need to see the code? It's somewhat rudimentary, so I'm a little embarrassed! LOL

 

[JLGWhiz]

I'm sorry, I'm new to writing macros. I'm ok with recording them, but writing is different. I have some macros in a workbook, and if I save it as a different workbook, it won't find the macros when I've assigned them Quick Access Toolbar shortcuts.

I must be missing some code somewhere...thoughts? Do you need to see the code? It's somewhat rudimentary, so I'm a little embarrassed! LOL

If you did not save the new file as a macro enabled workbook (.xlsm) then your macros were deleted by Excel during the SaveAs action.

 

[Domroy]

I do save it as an .xlsm, except I rename it and change the location. Then it tells me it can't find the macros.

 

[Fluff]

If you've changed the name of the file, then you'll need to reset the QAT as the shortcuts will still be pointing to the original file

 

[Domroy]

Hmm...ok. I change the location of the file, but not the name, usually. And it still looks for another path.

 

[JonXL]

Are they getting saved in the personal workbook?

 

[Domroy]

No. I save them in the actual workbook. So, maybe I'm missing an "active workbook" line of code or something?