Macro to hide and unhide sheets by command button

[zhoney786]

Hi All

i have a workbook which contains multiple sheets. i want to put button on main sheet and want to display one sheet at a time.

like if i am on main sheet (all other sheet are hidden) and i am viewing all buttons from which i will decide which sheet to open (like sheet 1 or sheet 2) than main sheet will hide and sheet 1 or sheet 2 will open depending upon which button i have clicked.

secondly i want to place a main sheet button on every sheet which will take me back to main sheet and hide active sheet.

i will really greateful if somebody can help me with this macro i have tried alot of macros but not able to find a proper solution for this

 

[Dryver14]

Good morning

I just tried out this method

Sub Button4_Click()
Worksheets(2).Visible = True
Worksheets(5).Visible = False
End Sub

obviously you would need to reverse the proceedure on sheet2

 

[zhoney786]

thanks a lot mate but when i click on the button it gives me error 1004

Unable to set Visible property of the work sheet class

as i try to hide Main sheet and access another

please let me know what should i do now

 

[zhoney786]

This is code i have written

this code is for one button i have put on Main sheet

Private Sub Commercial_Click()
Worksheets(1).Visible = False
Worksheets(2).Visible = True
Worksheets(3).Visible = False
End Sub

this code is for home button which i put on second sheet from which i want to access main sheet and hide all others


Private Sub CommandButton1_Click()
Worksheets(1).Visible = True
Worksheets(2).Visible = False
Worksheets(3).Visible = False
End Sub

now can you suggest why it is giving error not able to set visible property. i have put these codes on sheet level not on worksheet level

 

[zhoney786]

please anybody help me out with this

 

[RichardMGreen]

If you only have three worksheets, you'll need to make sure one is visible at all times.
Reorder your code to make sure that happens and you should be fine.

 

[zhoney786]

Thanks alot Mr Green 3 sheets is just an example sheets must be 10 to 12 thats why want a code on buttons which will naviagte to sheets and return to main sheet through button my code is not working it hides sheets first time after that it gives error which i have written above so please help me out with the code

 

[RichardMGreen]

Instead of using false for hiding sheets, try using xlhidden.
Apart from that I can't see anything wrong.