lock sheets but not buttons

**Sonyk** · 09-18-2009, 11:22 AM

i have a problem. When I lock a sheet, all the combo boxes and tick boxes are locked too. I want to lock the sheet but allow function with comboboxes and all the buttons and stuff...

apreciated

**royUK** · 09-18-2009, 12:44 PM

What kind of controls are you using? What is not working with the controls?

**Palmetto** · 09-18-2009, 01:54 PM

This may be helpful.

Run Macros On Protected Worksheets

**Sonyk** · 09-20-2009, 08:59 PM

Originally Posted by royUK

What kind of controls are you using? What is not working with the controls?

the combo boxes (the boxes when you click appear more than one thing to choose in a list, you know?)

when i protect the sheet it doesnt allow me to use that control and also the "tick boxes"

**amitmodi_mrt** · 09-20-2009, 09:42 PM

While locking the sheet, check "Edit Objects", and then lock your sheet.

**Sonyk** · 09-21-2009, 07:48 AM

its not working... i lock the sheet and tick edit objects but when i click in a combo box or in a tick box the message that the shhet is locked appears and i cant change nothing

**andrewyang** · 09-23-2009, 01:06 AM

mybe you should perfect you macro,using code change the protection status,before running the macro----release the sheet,when then "sub" over locked the sheet again

Private Sub ComboBox1_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
On Error Resume Next
Sheets(1).Unprotect Password:="123"
End Sub

Private Sub ComboBox1_LostFocus()
On Error Resume Next
Sheets(1).Protect Password:="123"
End Sub