Two open problems

[Jack]

Hi
How can I get a file to open on the same tab all the time. The second
question I have is how can I have a sheet that I goto open at the next empty
cell for entering data.

Thank you

 

[JE McGimpsey]

One way:

Put this macro in the ThisWorkbook code module (if you're not familiar
with macros, see David McRitchie's "Getting Started with Macros"

http://www.mvps.org/dmcritchie/excel/getstarted.htm

for help).

Private Sub Workbook_Open()
Me.Sheets("Sheet1").Select
End Sub

change the name as necessary.

 

[Frank Kabel]

Hi
both would require VBA. For the first one put the following code in your
workbook module
private sub workbook_open()
me.worksheets("sheet2").activate
end sub

 

[JE McGimpsey]

One way:

Put this in the worksheet code module (right-click the worksheet tab and
choose View Code):

Private Sub Worksheet_Activate()
With Me.Cells(Rows.Count, 1).End(xlUp)
If IsEmpty(.Value) Then
.Activate
Else
.Offset(1, 0).Activate
End If
End With
End Sub