"mangesh_yadav " wrote in
message ...
Is it not possible to use controls in a protected sheet. My comboboxes
and checkboxes are not working in a protected sheet. How do I make them
work.

Try adding this to the Workbook.Open event:

With Sheets("Sheet1") 'or whatever your sheet is called
.EnableAutoFilter = True 'remove this line if you are not using an
autofilter
.Protect DrawingObjects:=True, _
contents:=True, Scenarios:=True, UserInterfaceOnly:=True
End With

Please post back if this works.

Iain King