Some terrific ideas here. Thanks, all!
I've got another (related) question. One of my 'must have' toolbar buttons is a Protect Sheet / Unprotect Sheet button. How can I get that to toggle 'pressed' or 'not pressed' to SHOW me the protection status of the sheet, without having to do trial and error or show the text of the button? If I leave the button in 'text' mode, the caption does change to show what the next button push will do. But I'd like to save toolbar space by not showing the caption text.
If that's not clear, I'm trying to get the button itself to change its appearance the way the 'Drawing', 'Bold', 'Underline', etc. buttons do. (Which is kind of silly, when you think of it, because when the Drawing button has been pressed YOU GET A NEW TOOLBAR! When the Bold button's pressed you get bold text, etc. So why does one need to know if those buttons are pressed or not?)
Sorry for the rant. Thanks again.
Chris