How to move worksheet into specific position?

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

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
 
Eric,

This can go in several events modules. Change Sheet1 to the name of the
desired sheet

Application.Goto Sheets("Sheet1").Range("I54"), scroll:=True

Private Sub Workbook_Open()
Private Sub Worksheet_Activate()
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Should due the trick
Private Sub Workbook_Open()
With ActiveWindow
.ScrollRow = 45
.ScrollColumn = 9
End With
Range("I45").Activate
End Sub
 
Thank you very much, it works
Eric

Mike H said:
Eric,

This can go in several events modules. Change Sheet1 to the name of the
desired sheet

Application.Goto Sheets("Sheet1").Range("I54"), scroll:=True

Private Sub Workbook_Open()
Private Sub Worksheet_Activate()
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
Click to expand...
 
Back
Top