VBA Code

Wildsmeister · #1 (**permalink**) 02-16-06, 07:59

Hi,

I need what I am sure is a really easy bit of code on an excel workbook.

I need to ensure that whenever a spreadsheet I have created is opened, it always defaults to a certain worksheet, irrespective of which worksheet it was saved on.

Hope someone can help

Cheers
Paul

MikeTheBike · #2 (**permalink**) 02-16-06, 08:47

Hi

Try this code in the 'ThisWorkbook' module

Code:

Private Sub Workbook_Open()
    On Error Resume Next
    Worksheets("YourSheetName").Select
End Sub

The On Error code causes errors to be ignored if the sheet name does not exist.

HTH

MTB

Wildsmeister · #3 (**permalink**) 02-16-06, 09:50

Thats perfect Mike Cheers

Paul

Fazza · #4 (**permalink**) 02-16-06, 18:14

Some other thoughts.

You could have some similar code to that offered by Mike but running on file closure. If it is critical, you might also consider if the file is opened without macros enabled. And, in case the worksheet name changes, use the CodeName property.

regards,
Fazza

Internet Services

Web Development

Digital Marketing

Consumer Tech