Excel workbook problem

Excel workbook problem

Didn't find your answer?

In Excel I have inherited a spreadsheet which always jumps to the same sheet within the workbook whenever you click back on Excel, regardless of which sheet you were last working on - e.g working on sheet 3, then change to another application, then click back on Excel again and the screen jumps back to sheet 1. How do you turn this off, (and back on).
Anon

Replies (1)

Please login or register to join the discussion.

avatar
By ACDWebb
12th Apr 2006 00:13

Look in the VB editor
Press Alt & F11 to start it up.

In the ThisWorkbook module under Microsoft Excel Objects you will probably find an entry as follows:

Private Sub Workbook_Activate()
Sheet3.Activate
End Sub

Which selects Sheet3 when you activate the workbook.You will need to amend that, possibly by putting ' in front of the line that selects the sheet. This makes the line a comment rather than code that will be acted on by VBA

Thanks (0)