ExcelBanter - startup sheet?

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - startup sheet? (https://www.excelbanter.com/new-users-excel/94337-startup-sheet.html)

Hi there...
Is there a way to select which sheet will be displayed when a workbook
is opened? There does not seem to be any rhyme or reason to this.
TIA!
John

As far as I know it will open up to whatever sheet was open when last saved.
(And thats what happened when I did a little test just now.)

"Johnnyjomp" wrote:

Hi there...
Is there a way to select which sheet will be displayed when a workbook
is opened? There does not seem to be any rhyme or reason to this.
TIA!
John

"Johnnyjomp" wrote:
Is there a way to select which sheet will be displayed
when a workbook is opened ?

If we want it to open always with say, Sheet1's A1 selected,
we could tinker with this ..

Right-click on the Excel icon* View Code
*icon just to the left of "File" on the main menu bar
(Above will bring us direct into the "ThisWorkbook" code window)

Then copy paste the code below into the code window

'----
Private Sub Workbook_Open()
Sheets("Sheet1").Select
Range("A1").Select
End Sub
'----

Press Alt+Q to get back to Excel. Save the file after typing something in a
cell on another sheet (other than Sheet1), close and exit. Test it out by
re-opening the file. It should open in Sheet1's A1.

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---