How to move worksheet into specific position?
 

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

How to move worksheet into specific position?
 

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.


"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

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

How to move worksheet into specific position?
 

Thank you very much, it works
Eric

"Mike H" wrote:

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.


"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