View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default How to move worksheet into specific position?

Should due the trick
Private Sub Workbook_Open()
With ActiveWindow
.ScrollRow = 45
.ScrollColumn = 9
End With
Range("I45").Activate
End Sub

"Eric" wrote:

Does anyone have any suggestions on how to move worksheet into specific
position? I would like to re-locate the worksheet (my sheet) into I45
position whenever I open it, so cell I45 will be the first row and column
within my sheet.
Does anyone have any suggestions on how to create a macro for my sheet?
Thanks in advance for any suggestions
Eric