In Excel 2007 there is a way to add an Icon to the Quick Access Toolbar (QAT) so that only shows when the file containing the macro that the Icon is assigned to is open.
The image post at https://www.screencast.com/t/HEalSvrBYI0 is something that I create some time ago to document the process of doing this. And at that time I think that this "Conditional" QAT Icon feature also worked in 2010.
PLEASE NOTE: THE STEP DOCUMENTED AT THE TOP RIGHT OF THIS IMAGE IS THE STEP THAT SEEMS TO NOT BE POSSIBLE IN 2010 AND LATER VERSIONS OF EXCEL.
IN EXCEL 2007 YOU ACTUALLY CHOOSE THE OPEN FILE CONTAINING THE MACRO AND THE REMAINING STEPS WORK AS SHOWN.
HOWEVER, IN EXCEL 2010, WHILE YOU CAN CHOOSE A FILE FROM THIS DROPDOWN, FROM THAT POINT FORWARD THE PROCESS IS PROBLEMATIC, AS THE MACRO IN THE DIALOG DISAPPEARS, AND SO IT'S NOT A WORKABLE PROCESS.
BUT, IN 2010+ YOU CAN ASSIGN A MACRO TO A BUTTON (WITHOUT USING THE DROPDOWN BEING REFERRED TO) AND THE FILE PATH ASSOCIATED WITH THAT MACRO WILL BE USED TO OPEN THE FILE.
HOWEVER, IF THE FILE IS MOVED THEN THE MACRO NO LONGER RUNS. AND SO I'D LIKE TO IMPLEMENT THE "2007 'CONDITIONAL' QAT ICON METHOD" BUT DON'T KNOW HOW TO DO IT WITHOUT RUNNING INTO PROBLEMS IN THE PROCESS OF TRYING TO SET IT UP AS IN 2007.
MIGHT SOMEONE HAVE AN ANSWER TO THIS PROBLEM?
===================================
PS: THE FILE TYPE MUST BE .XLSM NOT .XLS IN ORDER FOR THE DROPDOWN TO SHOW THE MACRO FILE.
The image post at https://www.screencast.com/t/HEalSvrBYI0 is something that I create some time ago to document the process of doing this. And at that time I think that this "Conditional" QAT Icon feature also worked in 2010.
PLEASE NOTE: THE STEP DOCUMENTED AT THE TOP RIGHT OF THIS IMAGE IS THE STEP THAT SEEMS TO NOT BE POSSIBLE IN 2010 AND LATER VERSIONS OF EXCEL.
IN EXCEL 2007 YOU ACTUALLY CHOOSE THE OPEN FILE CONTAINING THE MACRO AND THE REMAINING STEPS WORK AS SHOWN.
HOWEVER, IN EXCEL 2010, WHILE YOU CAN CHOOSE A FILE FROM THIS DROPDOWN, FROM THAT POINT FORWARD THE PROCESS IS PROBLEMATIC, AS THE MACRO IN THE DIALOG DISAPPEARS, AND SO IT'S NOT A WORKABLE PROCESS.
BUT, IN 2010+ YOU CAN ASSIGN A MACRO TO A BUTTON (WITHOUT USING THE DROPDOWN BEING REFERRED TO) AND THE FILE PATH ASSOCIATED WITH THAT MACRO WILL BE USED TO OPEN THE FILE.
HOWEVER, IF THE FILE IS MOVED THEN THE MACRO NO LONGER RUNS. AND SO I'D LIKE TO IMPLEMENT THE "2007 'CONDITIONAL' QAT ICON METHOD" BUT DON'T KNOW HOW TO DO IT WITHOUT RUNNING INTO PROBLEMS IN THE PROCESS OF TRYING TO SET IT UP AS IN 2007.
MIGHT SOMEONE HAVE AN ANSWER TO THIS PROBLEM?
===================================
PS: THE FILE TYPE MUST BE .XLSM NOT .XLS IN ORDER FOR THE DROPDOWN TO SHOW THE MACRO FILE.
