HIDDEN SHEET

[verluc]

I have a workbook with 3 sheets.
I want by opening this workbook,that autmatickly sheet1 is hidden.
Can somebody help me with a macro to do this?
Many thanks in advance.

[Tom Schreiner]

Here you go:

Private Sub Workbook_Open()

Sheet1.Visible = xlSheetHidden

End Sub

Tom

[klb]

Why not just hide the sheet before you save it and when you open it the next time it will be hidden?

[verluc]

On 2002-05-07 05:49, TsTom wrote:
Here you go:

Private Sub Workbook_Open()

Sheet1.Visible = xlSheetHidden

End Sub

Thanks,Tom,but where do I insert this macro?
Many thanks for answer.




Tom

[Tom Schreiner]

From your Excel worksheet, rightclick on the
Excel icon immediately left of your file menu item(Upper left hand corner), choose "View Code", paste this code there.

If the procedure already exists, then just paste the one line into the existing procedure.

Should end up in your workbook class module.

Tom

[verluc]

On 2002-05-07 06:15, TsTom wrote:
From your Excel worksheet, rightclick on the
Excel icon immediately left of your file menu item(Upper left hand corner), choose "View Code", paste this code there.

If the procedure already exists, then just paste the one line into the existing procedure.

Should end up in your workbook class module.

Tom

[/quote]
Hi,Tom,

I have insert your macro on the place it must.But when I run the macro(open the workbook) then there is another sheet that is hidden and not Sheet1
Any idea?
Thanks

[Mark O'Brien]

Use :

Private Sub Workbook_Open()

  Sheets("Sheet1").Visible = xlSheetHidden

End Sub

This causes the sheet called "Sheet1" to be used and not the programmatic "Sheet1".

The difference is that the sheet called "Sheet1" has the name "Sheet1" on the worksheet nametab.

The programmatic "Sheet1" is the first sheet that was added to the workbook. You've either deleted this or named it something else.

HTH

[verluc]

On 2002-05-07 06:48, Mark O'Brien wrote:
Use :

Private Sub Workbook_Open()

  Sheets("Sheet1").Visible = xlSheetHidden

End Sub

This causes the sheet called "Sheet1" to be used and not the programmatic "Sheet1".

The difference is that the sheet called "Sheet1" has the name "Sheet1" on the worksheet nametab.

The programmatic "Sheet1" is the first sheet that was added to the workbook. You've either deleted this or named it something else.

HTH

Thanks Marc and Tom,it works fine now.
Great help.