Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Folks!
I have a sheet within which are all the Counties in the UK. To protect the data from being altered, I usually unlock cells and protect sheet. I cannot find a way to enable check boxes once the sheet is protected...!!!!!! This seems rudimentary, so I MUST be missing something. I want a user to be able to: 1/ tick or clear a check box to indicate whether he delivers to a certain County whilst the sheet is protected. 2/ tick or clear a single check box to operate several others; in other words, if a user selects ENGLAND, all the english counties are automatically selected. Any assistance that can be provided will be most appreciated - thank you very much, in anticipation. Kind regards, Dexxterr |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mutiple Check boxes flashing on sheet | Excel Discussion (Misc queries) | |||
How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) | |||
spell check in an Excel protected sheet | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
How to enable grouping in a protected sheet | Excel Worksheet Functions |