| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Move a worksheet position | Excel Programming | |||
| Adding a worksheet within the workbook at specific position | Excel Programming | |||
| Move Specific Data to Another Worksheet | Excel Worksheet Functions | |||
| Move Specific Text to new worksheet | Excel Programming | |||
| Change position of move or copy worksheet option in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
