How to move worksheet into specific position?
in [Programming]
|
Prev: testing for password protection
Next: Automatically OPENing (GetObject) and Closing EXCEL via VB calls
From: Eric on 27 May 2010 17:02 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 27 May 2010 17:51 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 27 May 2010 17:53 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 1 Jun 2010 09:04
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 |