Sheet protection

[pmss]

Hello

I am using checkbox (from control toolbox) to hide and unhide some rows in
the sheet. I want to protect this sheet with password but Checkbox should
work properly after protecting the sheet.

Thanks

 

[dave m]

If you add the protection for sheet and check the box that allows all users
to " Format Rows" and/or "Format Columns" then your checkbox will work.
All Cells on the sheet will still be protected.

Dave

 

[pmss]

thanks but i could not get your post properly.

If you add the protection for sheet and check the box that allows all users
to " Format Rows" and/or "Format Columns" then your checkbox will work.
All Cells on the sheet will still be protected.

Dave

 

[dave m]

do you mean you need more information on how to do this?

 

[pmss]

I have protected the sheet by simply from Tools - Protection - protect sheet
with password. But when i protect the sheet, checkbox does not work it gives
error message " Run time error 1004, Unable to set the hidden property of
the range class". so please possible write how to do it.

pmss

 

[dave m]

Go to Tool Protection and unprotect sheet.


Then go back in to Tools-Protection and Protect Worksheet.
Before you say OK, add a tick to the box marked Format Rows.
Then add your password and protect sheet.

Your Buttons should now work.


Dave

 

[pmss]

Thanks

Pmss

Go to Tool Protection and unprotect sheet.


Then go back in to Tools-Protection and Protect Worksheet.
Before you say OK, add a tick to the box marked Format Rows.
Then add your password and protect sheet.

Your Buttons should now work.


Dave