button caption

  1. S

    Dynamic Macro Name?

    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...
  2. M

    How to create an ActiveX button and add code to it (tell it what sub to run) using vba?

    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...
  3. G

    Button caption toggles whether on or off

    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...
  4. S

    Special requirements for Save As File dialog box

    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...

Some videos you may like

This Week's Hot Topics