Forum Discussion
My macros are disappearing
My macros are disappearing. It seems to be random. There are several tricks I can use to get them back, but the problem keeps coming back.
My Excel macros stopped working after I installed Win11 and re-installed Office 365.
I reinstalled the macros --- Word and PowerPoint macros work fine --- Excel macros do not.
Initially, the Excel macros worked, until I closed the xlsm. Now the macros no longer work. Selecting a macro icon results in the message, "Office has identified a potential security concern ... Enable ... Disable." ... then "Sorry, we couldn't find ..\Book1.xlsx ...." which is odd as I have no idea where it gets that xlsx name.
I have followed the items listed above, including creating a Personal.xlsb and placed it at C:\Users\xxx\AppData\Roaming\Microsoft\Excel\XLSTART.
Any other suggestions?
---
BTW It would be good if the Microsoft Excel code writers removed all of these restrictions, located in many setting locations. It would be best if they made adding Excel macros as easy to install as Word and PowerPoint macros. This problem with Excel macros has been around for a couple of decades.
I reinstalled the macros --- Word and PowerPoint macros work fine --- Excel macros do not.
Initially, the Excel macros worked, until I closed the xlsm. Now the macros no longer work. Selecting a macro icon results in the message, "Office has identified a potential security concern ... Enable ... Disable." ... then "Sorry, we couldn't find ..\Book1.xlsx ...." which is odd as I have no idea where it gets that xlsx name.
I have followed the items listed above, including creating a Personal.xlsb and placed it at C:\Users\xxx\AppData\Roaming\Microsoft\Excel\XLSTART.
Any other suggestions?
---
BTW It would be good if the Microsoft Excel code writers removed all of these restrictions, located in many setting locations. It would be best if they made adding Excel macros as easy to install as Word and PowerPoint macros. This problem with Excel macros has been around for a couple of decades.
bhs67 I feel your pain. Do the macros not work at all? Are they there when you hit ALT-F8?
If they are there and sometimes work, then my advice: Keep date-coded backup folders, and back them up frequently. Yeah, a pia, but this has saved me a ton of aggravation and F Bombs.
If they don't work at all, then sorry... no ideas.
Good luck.
- It's very interesting that when select alt-F8, it displays "Personal.xlsb.Black Black". It is finding Personal.xlsb! When I select "Run", it executes that macro and turns the font color to black!
What on earth is not set correctly?- I discovered the solution! File > Options > Quick Access Toolbar > Macros > select the macros that start with Personal.xlsb!
For example, select Personal.xlsb!Red > Add > Modify > select red icon. Now the red icon on the Quick Access Toolbar changes the font to red.
---
I'll repeat --- It would be good if the Microsoft Excel code writers removed all of these restrictions, located in many setting locations.
It would be best if they made adding Excel macros as easy to install as Word and PowerPoint macros.
This problem with Excel macros has been around for a couple of decades.
