I am using at the moment the following macro code to hide and unhide a
worksheet. Once i hide the worksheet i want to be able to have it take
you to a certain worksheet that i have not hidden what macro should I
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 Sub


--
broop
------------------------------------------------------------------------
broop's Profile: http://www.thecodecage.com/forumz/member.php?userid=26
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=71355