disabling cells based on cmd button

C

Consuelo

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 :)
 
R

Ron de Bruin

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
locking and unlocking a textbox using command buttons 1
Program buttons to create a word document 0
Refreshing the form / cmd button to effect underlying changes 1
Cmd button text colour and caption not changing 0
Disable cmd button - focus problem 2
Disable Command Button 1
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2

Top