| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limiting a worksheet's selection range.
On Apr 20, 1:46 am, Barb Reinhardt
wrote: It seems that it's related to what you can choose to display (Locked cells, unlocked cells) when you protect the worksheet. I generally allow a display of unlocked cells only and that may be why we are seeing a disconnect. try replacing the PROTECT (for the worksheet) with this. I'm not sure it will work .Protect UserInterfaceOnly:=True Thanks for solving that problem for me Barb. I must do some reading on that UserInterfaceOnly thing. Ken Johnson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table limiting user selection | Excel Discussion (Misc queries) | |||
| Limiting selection in a cell AND linking that selection to a list | Excel Discussion (Misc queries) | |||
| Limiting the range of AutoFilter? | Excel Worksheet Functions | |||
| Limiting the range of a lookup function | Excel Worksheet Functions | |||
| Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue. | Excel Programming | |||
Threaded Mode
