CommandButton caption set on open

[JimDandy]

How do I set the CommandButton.Caption value specifically when the worksheet is opened. I use commands to change the caption every time the button is pressed but I want to make sure that every time the worksheet is opened the caption for the buttons always start out with a specific caption. If the worksheet is saved with the wrong button caption, my functions don't work correctly.

[Leith Ross]

Hello JimDandy,

Place your code to change the Command Button captions in the Workbook_Open() event module. If you are calling macros from another module to do this rather than having the code resident in the Open module, you will need to prefix the macro call with the name of the module it is in or it won't work. For example, let's say you have a macro named Caption1Macro in Module1. In the Open event module it would be written as Module1.Caption1Macro

[JimDandy]

Great! Thank you...much appreciated