| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Restrict cells selected to specific range name
HI,
I would like to restrict selection of cells to only a range say the dimensions of a range name. Is this possibly in VBA please. EG My rangename is Weeks which is the range A1:B10 and i dont want any users to access cells outside of this range. Hope that makes sense. Thanks JB |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Restrict cells selected to specific range name
try using Scrollarea property
to set scrollarea Worksheets(1).ScrollArea = "A1:B10" to clear Worksheets(1).ScrollArea = " " -- jb "John" wrote: HI, I would like to restrict selection of cells to only a range say the dimensions of a range name. Is this possibly in VBA please. EG My rangename is Weeks which is the range A1:B10 and i dont want any users to access cells outside of this range. Hope that makes sense. Thanks JB |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Start Macro when specific Cells are selected | Excel Programming | |||
| Protect/Restrict usage of a range of cells. | Excel Discussion (Misc queries) | |||
| selecting a specific cell within a selected range | Excel Programming | |||
| How to restrict the TitleRow only for a specific range of rows? | Excel Programming | |||
| Execute a Macro when specific value is selected in a Range | Excel Programming | |||
Linear Mode
