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

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top