Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet protection
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet protection
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" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet protection
thanks but i could not get your post properly.
"dave m" wrote: 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" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet protection
do you mean you need more information on how to do this?
"pmss" wrote: thanks but i could not get your post properly. "dave m" wrote: 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" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet protection
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" wrote: do you mean you need more information on how to do this? "pmss" wrote: thanks but i could not get your post properly. "dave m" wrote: 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" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet protection
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" wrote: 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" wrote: do you mean you need more information on how to do this? "pmss" wrote: thanks but i could not get your post properly. "dave m" wrote: 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" wrote: 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet protection
Thanks
Pmss "dave m" wrote: 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" wrote: 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" wrote: do you mean you need more information on how to do this? "pmss" wrote: thanks but i could not get your post properly. "dave m" wrote: 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" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sheet Protection | Excel Discussion (Misc queries) | |||
Sheet protection on MAC | Excel Discussion (Misc queries) | |||
Sheet Protection | Excel Discussion (Misc queries) | |||
Sheet Protection | Excel Discussion (Misc queries) | |||
Sheet Protection | Excel Worksheet Functions |