Make sheet active when workbook opens

VBALordCorp · #1 (**permalink**) 07-28-04, 14:02

I need to make sure that everytime the workbook opens it opens to sheet1

The Activate Method code doesn't seem to be working I keep getting an error

ThisWorkbook.Worksheet("Sheet1").Activate

How do I take care of this?

shades · #2 (**permalink**) 07-28-04, 14:14

Try this:

ThisWorkbook.Worksheets("Sheet1").Activate

VBALordCorp · #3 (**permalink**) 07-29-04, 09:33

That was a no go it still isnt working. The caption of the work book is open ECN's. Sheet one's tabe is "open ECN log" but in the VBA tree they are still Thisworkbook and sheet1. have any more advice?

shades · #4 (**permalink**) 07-29-04, 09:57

This is the code that should work. I used "mySheet" as the worksheet name for the test. Put in the actual name of your worksheet.

Code:

Private Sub Workbook_Open()
    Worksheets("mySheet").Activate
End Sub

Where are you putting this code? It should not go in a general module. If you are in Excel, go to icon to left of File, right click and select "View Code". Then in VBE, in upper left dropdown, select Workbook. Then put this code.

VBALordCorp · #5 (**permalink**) 07-29-04, 10:31

thanks that worked!!!!!

Internet Services

Web Development

Digital Marketing

Consumer Tech