hkeiner
11-09-2010, 03:41 PM
Is there a way to add/delete a macro enabled Icon on the Quick Access Toolbar using VBA code? The QAT Icon would be mapped to a certain module.sub on the Normal template. I know how to do this manually using dialog boxes, but I want to be able to do this via VBA code.
My objective is to have the Icon appear in the QAT only when certain documents are opened. I already know how to use AutoOpen and AutoClose subs to conditionally add/remove userforms and modules on the Normal Template when these documents are opened, but I have not found a way to do something similar with macro enabled QAT icons.
I am guessing that this is not possible, but I thought I might ask.
Thanks
My objective is to have the Icon appear in the QAT only when certain documents are opened. I already know how to use AutoOpen and AutoClose subs to conditionally add/remove userforms and modules on the Normal Template when these documents are opened, but I have not found a way to do something similar with macro enabled QAT icons.
I am guessing that this is not possible, but I thought I might ask.
Thanks