Hello.
I have an Excel 2010 workbook with a couple of macro buttons which have been added to the QAT for that document only so they appear when then file is open and disappear when it is closed.
I would like to distribute this document, but only have the buttons appear if the file is in a certain folder on a shared drive, so that some users see it and others, loading to from somewhere else, do not. I guess I can add code to recognise the file path, but my question is... How can I remove or hide the buttons from the QAT using VBA (not any built in buttons, just the ones I have added).
any help/pointers appreciated!
Gary
I have an Excel 2010 workbook with a couple of macro buttons which have been added to the QAT for that document only so they appear when then file is open and disappear when it is closed.
I would like to distribute this document, but only have the buttons appear if the file is in a certain folder on a shared drive, so that some users see it and others, loading to from somewhere else, do not. I guess I can add code to recognise the file path, but my question is... How can I remove or hide the buttons from the QAT using VBA (not any built in buttons, just the ones I have added).
any help/pointers appreciated!
Gary