View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default about protection

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