| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
disabling cells based on cmd button
HELLO,
I AM TRYING TO FIGURE OUT HOW TO MAKE CERTAIN CELLS DISABLED BASED ON AN CMD BUTTON'S (ON USER FORM) ONCLICK EVENT. PLEASE HELP! CONSUELO :-) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
disabling cells based on cmd button
Nor sure if I understand you correct?
But try this Private Sub CommandButton1_Click() Sheets("sheet1").Unprotect Sheets("sheet1").Range("a1:c1").Locked = True Sheets("sheet1").Protect End Sub -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Consuelo" wrote in message ... HELLO, I AM TRYING TO FIGURE OUT HOW TO MAKE CERTAIN CELLS DISABLED BASED ON AN CMD BUTTON'S (ON USER FORM) ONCLICK EVENT. PLEASE HELP! CONSUELO :-) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disabling copy/paste hidden cells | Excel Worksheet Functions | |||
| Conditional Formatting Based of Cells Based on Data Entry in anoth | Excel Discussion (Misc queries) | |||
| Create a toolbar button based on three steps | Excel Discussion (Misc queries) | |||
| enable/disable button based on cell value | Excel Discussion (Misc queries) | |||
| Disabling font color button | Excel Programming | |||
Linear Mode
