Hiding / Unhiding sheets

Hi!

Probably very basic question, but I'm VBA newbie.

I have 6 sheets on my workbook.

Sheet1, Sheet2, Sheet3, Sheet4 are visible
Sheet5, Sheet6 are hidden

I need to assign macro to the button on Sheet4 to hide Shee3 and Sheet4 and unhide Sheet5 and Sheet6.
So it was 1,2,3,4 and should be 1,2,5,6.

Any ideas?

Originally Posted by PaulM100

Something like this:

Please Login or Register  to view this content.

The numbers represent the sheet numbers. you can replace them with sheets names, like 3 becomes "Sheet3"

Thanks Its so easy :D