- Outlook 2010 cannot customize quick access toolbar update#
- Outlook 2010 cannot customize quick access toolbar pro#
I also exported by Quick Access Toolbar using the built-in Export feature I then opened the file in a text editor (Notepad++) and did a find/replace to change PERSONAL.XLSB to Macros.xlsm. I saved the file in the same location as PERSONAL.XLSB. I exported all the modules from my PERSONAL.XLSB file, and imported them into a new file, called Macros.xlsm.
It looks like the problem only occurs in the PERSONAL.XLSB workbook more importantly, any other file saved in the default XLSTART folder does not experience the problem. I am at a complete loss, and in a horrible pit of despair (not actually, but I will go ahead and play the victim in this situation).
Outlook 2010 cannot customize quick access toolbar update#
The guys from IT also rolled back a security update (KB2553154), which changed absolutely nothing. WHY?!Įarlier, per help desk suggestion, I attempted to "repair" the Office installation. It works just fine! So the problem is limited to just the one computer, and only Excel and not the rest of Office on top of that, it is limited to just PERSONAL.XLSB macros, because everything else seems to work without a problem. I also exported both the PERSONAL.XLSB and the QAT customization, then installed both on another workstation (on the same network). It still doesn't work when added to the QAT, but runs just fine when executed from VBE or Alt+F8 macro dialog box. In a brand new PERSONAL.XLSB, I created a simple macro (MsgBox "Hello World"). I tried to delete and re-create the PERSONAL.XLSB. If I add a Sub from a new workbook, or an add-in, it works just fine. Update: apparently, only the macros in my PERSONAL.XLSB do not work from the Quick Access Toolbar. I hope someone has dealt with this problem successfully in the past Appreciate any suggestions. Those don't work either.Ĭustomizing built-in commands works just fine, existing ones and any new ones added. So it's isolated to just one workstation.Īlso, I tried to create a custom ribbon tab, and add macros there. Then I tried to import the same file on another machine, and it worked there. I exported the toolbar, and examined the XML - appears fine. No new (or old) macros added to the QAT run. I have tried removing and re-adding the buttons, and resetting the toolbar - doesn't work. The macros still work just fine, and in the Customize menu it says the correct path and name for each one. I have a large number of macros, stored in PERSONAL.XLSB, that I have assigned over time to buttons on my quick access toolbar (QAT). Now I am experiencing this issue and it's driving me crazy. I've seen this asked before around the Internet, but did not see any good answers.
Outlook 2010 cannot customize quick access toolbar pro#
Excel 2010, Office Pro Plus, Windows 7, everything 32 bit.
0 kommentar(er)
