button caption

Hi, I'm not sure this is possible but thought it would be worth asking. I have the following code below, which hides a tab based on a cell. Ideally I'd like a macro button to say "Hide Tab" when it's unhidden and "Unhide Tab" when it's hidden. Thanks for reading, any suggestions welcome...

Hello. I'd like to create an ActiveX button in a sheet and assign a code to it (i.e. tell it to what sub to run and that sub already exists). I can create the button: (recorded) ActiveSheet.OLEObjects.Add(ClassType:="Forms.CommandButton.1", Link:=False _ , DisplayAsIcon:=False...

Dear All, Using Excel 2003, I am looking for a way to have a button where the caption toggles (changes) whether the button is on or off. I want the caption to read "US Dollars" when the button has not yet been pressed, to read "Canadian Dollars" after the button has been pressed, and to...

Hello, I want to open Save As File dialog box in Excel. I need it to have these features: 1) ability to add filters (msoFileDialogSaveAs does not support it) 2) ability to change Save As button text 3) Unicode support I was able to get all my mentioned functionality with...