Only one tab at a time?

[User Name:]

Hi everyone,

I’m creating an Excel workbook with Hyperlinks to navigate around the workbook (i.e. on ‘Sheet1’ you can click a cell that will take you to ‘Sheet2’)

Well that is easy enough but the problem is I only want to see one tab (the current tab) at a time (I don’t want to just hide all tabs)

Is there a macro I can write?

Thanks

UN

 

[Mihail]

Pseudo-code:

Dim Sh As Worksheet
For Each Sh in Worksheets
     Sh.Visible = (Sh.Name = ActiveSheet.Name)
Next Sh