Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Ulf,
protecting the worksheet against user selection maybe you should use a combination of protected sheets, protected cells, hidden formulas and scroll area. And there is a possibility in VBA to restrict access only to unprotected cells, this requires sheet protection, too: activesheet.ENABLESELECTION = xlUnlockedCells Otherwise you should restructure your sheets so that the user input area is in one certain range where you could use the scroll area. bye arno |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2000 - Autofilter Limit | Excel Worksheet Functions | |||
Worksheet Navigation | Excel Discussion (Misc queries) | |||
Excel worksheet tabs navigation | Excel Worksheet Functions | |||
Limit in the number of Dataqueries in Excel 2000 | Excel Programming |