What formula should I use?

[broop]

I am using at the moment the following macro code to hide and unhide
worksheet. Once i hide the worksheet i want to be able to have it tak
you to a certain worksheet that i have not hidden what macro should
use to accomplish this?

Sub HiddenFormulasnewvision()
'
' HiddenFormulasnewvisionPage Macro
' Macro recorded 10/14/2008 by
'

'
ActiveWindow.SelectedSheets.Visible = False
End Sub

Sub UnhideFormulasnewvision()
Sheets("Formulas new vision").Visible = True
Sheets("Formulas new vision").Select
End Su

 

[Bernard Liengme]

Sub hideme()
Worksheets("Sheet1").Visible = False
Worksheets("Sheet3").Activate
End Sub