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.
But how do I add it to this code?
Please Login or Register to view this content.
Thanks in advance.Please Login or Register to view this content.
Last edited by JohnDoh; 08-28-2015 at 05:43 AM.
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 :
Incorporated into your code would look something like :Please Login or Register to view this content.
HTHPlease Login or Register to view this content.
DominicB
Thanks for the reply
That makes sense, but I get an error @This is another noon question, does the fact that I have more than one button make any difference, does each one have a reference?Please Login or Register to view this content.
Couldbe referring to the wrong button?Please Login or Register to view this content.
Hi John
From Developer tab >> click Insert >> draw Toggle Button (ActiveX Control) >> Double click it and in VBE put this code
From Developer tab >> Click Design mode to exit it ..Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Of course, sorry school boy error.
Many thanks to you both.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks