| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Command button wz 2 function
Hi Excel experts,
I want to have my Cmd button to use as follow 1st click protect the sheet with a password"123" already written in the macros then 2nd click same button i got the input box to insert the password to unlock the sheet that is Lock and Unlock sheet with same Button also If I can have on the button "LOCK" when the sheet is unlock and "UNLOCK" whenthe sheet is locked so thet when a user see the button he/she know that the sheet is whether await Lock or Unlock Thanks very much for your help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert a function through a command button | Excel Programming | |||
| Assign Function to a Command Button | Excel Discussion (Misc queries) | |||
| command button function | Excel Programming | |||
| Command Button Function | Excel Programming | |||
| command button to do F9 function | Excel Programming | |||
Threaded Mode
