Showing related tags and posts accross the entire site.
-
Jeff It is tough to know what the answer was, but I still suspect that the wrong personal.xls or personal.xlsb was being opened. Have you tried following the steps I gave in my earlier post? If we start there, we can run through other steps if it doesn't work. Let us know
-
petedavo You will need to prefix them with the workbook name, the simplest way to attribute code to the QAT button is to right click on it select customize, then macros from the drop-downa and just add them This way I the Personal.xlsb! will be added automatically. I am confused as to the 'pen drive...
-
petedavo There should be no issue with the macros firing from a QAT button, providing the workbook is open (albeit hidden). I have suspicions that the code is in the 'wrong' personal file or you do not have it in an xlStart folder that Excel is recognising. This can vary depending on your installation...