custom toolbar button that visually toggles in and out

P

Paul Simon

Excel has a few toolbar buttons that are toggle buttons. For example
- the Toggle Grid button on the Forms toolbar or the Design Mode
button on the Control toolbar. The visual appearance of these buttons
changes as you toggle them "in and out".

I know how to create a custom toolbar button that toggles code that's
assigned to it (for example: ActiveCell.Font.Bold = Not
ActiveCell.Font.Bold) but the visual appearance of such a custom
toolbar button doesn't change, so the user cannot tell which state
it's in. I've even tried assigning my macro to the Toggle Grid button
but that somehow disengaged its ability to change appearance as you
toggled it.

Is there any code that can cause a custom toolbar button to visually
appear to toggle "in and out" with successive clicks?

If that's not possible, is there any code that can change the
foreground color of the button as you "toggle" it? For example, if I
edited the button's image by drawing a solid square on it, is it
possible to have the color of the square change back and forth between
red and black as you "toggle" the button?

Many thanks,
Paul
 
P

Paul Simon

Rob,

TERRIFIC!! It works perfectly and is exactly what I was looking for!

Thank you so very much for you time and help - I really appreciate it.

Best regards,
Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom Images not showing in Ribbon toggle button 2
Problem setting the State of a custom Toolbar button 4
Toggle Button Format Options 1
Easy way to add my custom button on Excel 2010 quick access toolbar? 3
Creating custom toolbar 3
Disabling a forms 1.0 button 5
Deleted Custom Toolbar keeps returning. 3
to remove a custom Toolbar Button & macro 1

Top