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.