What formula should I use?
 

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

What formula should I use?
 

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

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"broop" wrote in message
...

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