View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ZipCurs ZipCurs is offline
external usenet poster
 
Posts: 103
Default Interupted Scrollarea

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.