From: Eric on
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
From: Mike H on
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
From: Mike on
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
From: Eric on
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