Limit worksheet navigation in Excel 2000
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
|