Adding button text change function to existing macro

[JohnDoh]

Hi All,

I'm trying to add a command to a macro I found, but being a noob I think I know the command just not how to insert it correctly.

I have a toggle button which locks and unlocks a workbook and I would like to change the button text when pressed.

Assuming the following is the correct command to do so.

Please Login or Register  to view this content.

But how do I add it to this code?

Please Login or Register  to view this content.

Thanks in advance.

[dominicb]

Good morning JohnDoe

Remember this is a togglebutton, so just changing the text on the button will do that permanently - after the first time it is clicked it will have no effect thereafter. You need to vary it based on the state of the button which will be true or false. Also, if it is a togglebutton you will need to use .ToggleButton1 and not .Command Button1.

Something like this would work :

Please Login or Register  to view this content.

Incorporated into your code would look something like :

Please Login or Register  to view this content.

HTH

DominicB

[JohnDoh]

Thanks for the reply

That makes sense, but I get an error @

Please Login or Register  to view this content.

This is another noon question, does the fact that I have more than one button make any difference, does each one have a reference?

Could

Please Login or Register  to view this content.

be referring to the wrong button?

[YasserKhalil]

Hi John
From Developer tab >> click Insert >> draw Toggle Button (ActiveX Control) >> Double click it and in VBE put this code

Please Login or Register  to view this content.

From Developer tab >> Click Design mode to exit it ..

[JohnDoh]

Of course, sorry school boy error.

Many thanks to you both.