Is it possible to modify a QAT macro icon using VBA code? I want to add a button that is Blue when Auto Calc is on and Red when it's off. I'd like to put the code in my personal macro wkbk so it's available in all worksheets/books.
If not possible in QAT, perhaps in the custom ribbon buttons?
not in the qat but you can use a getImage callback with a ribbon button to switch between images by invalidating the control. have you used custom ribbon controls before?
Josie
if at first you don't succeed try doing it the way your wife told you to
I have to some extent. I created a custom ribbon with buttons I use regularly so I don't have to keep going through the other tabs. I have yet to successfully assign a custom button to the ribbon that calls a macro from my personal macro wkst. Would love to go that way if you could help.
did you do it using xml or just through the 'customize ribbon' menu? you'll need xml for this task-look at the last examples here: http://www.rondebruin.nl/win/s2/win009.htm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks