Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ScrollArea | Excel Discussion (Misc queries) | |||
Code has been interupted - error message | Excel Discussion (Misc queries) | |||
Macro 'Code execution has been interupted' error after print? | Excel Programming | |||
ScrollArea | Excel Programming | |||
Code Execution has been interupted | Excel Discussion (Misc queries) |