Post haste macro not working update#
Post haste macro not working pro#

So it seems that macros are not working only when you call them by a click. (that macro pop up an input message, but is not relevant now). That means that when I try to save, another macro works properly. However, I have a macro working before saving. Please share if you have gone through this experience.I have a macro which works fine on my computer when I click its button but it does not work on different computers.Īll the macros on that excel file are not working when clicking on the button. Why did my shortcuts suddenly stop working? Why is it that only my PERSONAL.XLSB was affected? Why do the exact same files work perfectly fine on other computers, but not on this one? Why did the macros work from other interfaces, but not from the QAT? Why did this only happen for Excel, and not other Office programs? All are good questions deserving of a good answer. However, it leaves many questions unanswered. This is a decent workaround - simple enough, and without too many changes to 'business as usual'. Once I opened Excel, I imported the original modified toolbar file into my QAT.Īnd guess WAT! (pun intended) Now all my macros work again just as before - it is beautiful! I saved Macros.xlsm in my XLSTART folder. 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).

Post haste macro not working 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.

Post haste macro not working pro#

Excel 2010, Office Pro Plus, Windows 7, everything 32 bit.