View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff Smith[_2_] Jeff Smith[_2_] is offline
external usenet poster
 
Posts: 17
Default Positioning the cursor programatically

Hi,
I have a multi-sheet workbook where all "navigation" (from sheet to sheet)
is controlled by macros. The user is allowed (and indeed is encouraged) to
scroll up/down/left/right. However, Excel remembers the last position or
view for a particular spreadsheet. This is not desired and I would like all
entries to a sheet or range within a sheet to have "Cell A1" (or the left
uppermost cell in a range) positioned at the top, left-most cell on the
range viewed on the monitor.

Can someone help here? I'm sure it is simple but I can find no references
in the extensive VBA sites around.

Thanking you in anticipation,

regards

Jeff Smith