So did you read my first post?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"pmss" wrote in message
...
hi
check box doesnot work, when i protect the sheet. It gives Run time error
1004.
Unable to set the hidden property of the Range class.
pmss

"Bob Phillips" wrote:

What doesn't work, I gave many suggestions? You need to be more explicit.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"pmss" wrote in message
...


"Bob Phillips" wrote:

Do you mean that the checkbox doesn't work, or the code behind it?

If the former, either check the 'Edit objects' option in the
protection
dialog, or use a checkbox from the forms toolbar.

If the latter, unprotect the sheet before your code, then re-protect
it
afterwards.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"pmss" wrote in message
...
Hello

I have made one excel sheet using Macro code for hide some rows with
check
box. But i could not protect the sheet. If i protect it , check box
doesnot
work. Can you help me to protect sheet .

pmss


Thanks.

Still does not work. I have used following codes for check box.
Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then

Rows("18:39").Hidden = False
Else
Rows("18:39").Hidden = True

End If

End Sub

I want to protect this sheet. When i protect the sheet the check box
doesnot
work, it gives some error.

Pmss