Macros in Personal.xlsb NOT executing from QAT or Ribbon

[Col Delane]

I have numerous macros in my personal macro workbook (Personal.xlsb), many of which are generic tools (formula modifiers/fixers, formatting, etc.) that I have linked to buttons on my Quick Access Toolbar (QAT) or to custom tabs/buttons on my Excel Ribbon.

Until yesterday morning, this all worked just fine. However, when Excel (XL2010 on Windows 7 Professional on my employer's LAN) was launched upon PC startup (included in my network profile's Startup menu), the VBE opened and displayed an error (I think something like "Out of memory") - but as it was first thing on a Monday morning at work, I wasn't really paying attention, and thought just closing down and restarting would solve the problem. Alas, this was not to be!

Whilst Excel launches automatically on PC startup, my Personal.xlsb does not (I have a shortcut in my network profile's XLSTART folder that links to Personal.xlsb in a Dropbox folder).
In addition, after manually opening my Personal.xlsb (Workbook_Open event macros in that file do execute ) , my macros linked to buttons on my QAT or Ribbon will NOT execute (even new buttons I added as an experiment!). However, I can execute any underlying macro via the native Macros command on the Developer tab . It seems that the "link" between the button and the macro in VBE is broken, but I've checked the path under some of the QAT buttons and they seem fine, and as mentioned earlier, even newly added macro buttons will NOT execute - or something far more sinister and mysterious has occurred.

As I use many of these macros on a hourly/daily basis (I work with Excel all day every day), this problem is really hampering my work.

Any ideas, insights, possible solutions would be greatly appreciated.

 

[Michael M]

Have a read of the same problem in this previous thread....



https://www.mrexcel.com/forum/excel...-not-working-quick-access-toolbar-ribbon.html

AND here, for checking the status of your Personal.xls file

https://excelribbon.tips.net/T012233_Personal_Workbook_Fails_to_Load.html

 

[Col Delane]

Re: Macros in Personal.xlsb NOT executing from QAT or Ribbon [SOLVED]

Many thanks Michael - the problem is now solved.

My Personal.xlsb file had been disabled. Now, if only Microsoft would program Excel to alert the user that this action was taken!!

 

[Michael M]

Re: Macros in Personal.xlsb NOT executing from QAT or Ribbon [SOLVED]

.....you're kidding, right !!