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.
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?
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.
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.