Shane,
Here is what i have done... because i am on the Herddescription tab and i
want to go to another tab i put in the tab that i now want to bring up. But
when i apply the macro to the button it brings up an error highlighting the
Sub Button1_Click(). Am i doing something wrong?

Sub Button1_Click()
Sheets("HerdDescription").Visible = xlSheetVeryHidden
Sheets("Requirements").Visible = xlSheetVisible
Sheets("Requirements").Activate
End Sub
--
Thank you, Brenda


"ShaneDevenshire" wrote:

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