View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
arno arno is offline
external usenet poster
 
Posts: 184
Default 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