Thanks for the quick response.
I just reconfirmed this. If I lock the linked cells, the Check Boxes
indicate that the sheet must be unprotected first. I need to use the Check
Boxes and List Box with the sheet protected.
"Ron de Bruin" wrote:
Why not lock the cells and protect your sheet ?
--
Regards Ron De Bruin
http://www.rondebruin.nl
"ZipCurs" wrote in message ...
I have a worksheet that I am setting a variable ScrollArea, depending on how
much information is on the worksheet. This works fine. The problem is that
I have a couple of Check Boxes and a List Box in the field, and I do not want
their linked cells to be accessable.
The only reason for expanding the ScrollArea is so that I can see the
ListBox contents all at once, which I actually need.
I can move the linked cells out of the ScrollArea field, but this is a
painful solution, since these are referenced by multiple macros.
Thanks for any help.