Default Sheet When Workbook Opens ...

**Mhz** · 02-02-2007, 11:35 AM

Is there a way to have a certain or default sheet open everytime that workbook is opened?

Example: I have a Sheet Labled 'Start', but i also have 10 other worksheets.

Is it possible to have the worksheet labled 'Start' to open by default everytime
this workbook is opened?

Thanks for any help here...

**Carim** · 02-02-2007, 11:41 AM

Hi,

You need an event macro in ThisWorkbook module ...

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

**Mhz** · 02-02-2007, 11:44 AM

You're Excellent Carim! Thanks for the fast Respone...

Your Knowledge is Greatly Appreciated... Thanks

**Carim** · 02-02-2007, 11:46 AM

Glad it fixed your problem

Thanks for the feedback

**Mhz** · 02-02-2007, 11:50 AM

Carim, when I close and open the workbook, the start page is not opening.

does it have to be the first module code?

thanks..

**Carim** · 02-02-2007, 11:53 AM

No ...

As stated in my previous post, this event macro has to be stored into the module called "ThisWorkbook" ...

**Mhz** · 02-02-2007, 05:46 PM

Hi Carim, I don't see a Module Named ThisWorkBook. Is it something I have to create?

If so, How, And exactly where is this coding inserted in the module?

Thanks..

Default Sheet When Workbook Opens ...

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Default Sheet When Workbook Opens ...

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions