| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting visible range
I am interested in doing two separate things, both primarily for aesthetic
reasons. First, and more importantly, I would like to be able to set the visible area (e.g. A1:X150). Either, the user could not travel out of the area or it would simply not be visible. Hiding the unwanted range is possible seems a little over the top, but this would work fine. Is there something better? Second, is it possible to make it so that locked cells can not be selected or even hightlighted. Any help is appreciated. Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting visible range
What version(s) of Excel does this need to work in?
Select unlocked cells only: in the VBE select the sheet and in the property editor set "enableselection" to "xlUnlockedCells" Similarly "ScrollArea" will restrict movement in the sheet. Tim -- Tim Williams Palo Alto, CA "ZipCurs" wrote in message ... I am interested in doing two separate things, both primarily for aesthetic reasons. First, and more importantly, I would like to be able to set the visible area (e.g. A1:X150). Either, the user could not travel out of the area or it would simply not be visible. Hiding the unwanted range is possible seems a little over the top, but this would work fine. Is there something better? Second, is it possible to make it so that locked cells can not be selected or even hightlighted. Any help is appreciated. Thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting visible range
Wow, Just that easy. Thank you very much.
"Tim Williams" wrote: What version(s) of Excel does this need to work in? Select unlocked cells only: in the VBE select the sheet and in the property editor set "enableselection" to "xlUnlockedCells" Similarly "ScrollArea" will restrict movement in the sheet. Tim -- Tim Williams Palo Alto, CA "ZipCurs" wrote in message ... I am interested in doing two separate things, both primarily for aesthetic reasons. First, and more importantly, I would like to be able to set the visible area (e.g. A1:X150). Either, the user could not travel out of the area or it would simply not be visible. Hiding the unwanted range is possible seems a little over the top, but this would work fine. Is there something better? Second, is it possible to make it so that locked cells can not be selected or even hightlighted. Any help is appreciated. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart not visible -suspect scale setting? | Charts and Charting in Excel | |||
| setting visible (ie displayed) part of the worksheet | Excel Programming | |||
| setting range().hidden=True causes range error 1004 | Excel Programming | |||
| Help finding error setting range to Visible Cells | Excel Programming | |||
| error with setting "Items.Visible = True" | Excel Programming | |||
Linear Mode
