Hi,

Here is sample code

Sub Button1_Click()
Sheets("Sheet1").Visible = xlSheetVeryHidden
Sheets("Sheet2").Visible = xlSheetVisible
Sheets("Sheet2").Activate
End Sub

If this helps, please click the Yes button
--
Thanks,
Shane Devenshire


"Brenda" wrote:

I have created 8 buttons on "home page" which takes them to different hidden
sheets. On each of those hidden tabs is a button that says back to home. The
questions i have is i would like to have on those hidden tabs the same links
that are on the home page. In other words they wouldn't have to click the
home button to get to another tab. I hope this makes sense. But how would i
do this i also want the sheet to go back to being hidden once they click on
another button. What code would i use. I hope someone understand what i am
asking.
--
Thank you, JR