sheet hide/unhide

Hi,
I have written a code attached in the MIS workbook,where if I click on button 1 in sheet 2,it will go back to sheet 1 and hide sheet 2,where I am getting an error vice versa please unhide sheet 1,and you will see 2 buttons in sheet 1,first button is to hide,unhide all sheets except sheet 1 and second button to unhide sheet 1

Try to change this code:

Please Login or Register  to view this content.

With:

Please Login or Register  to view this content.

Regards,
Antonio

Hi by using the new code I am able to see sheet 2 and rest are hiden,but I want go back to sheet 1 and hide sheet 2

Try with this code:

Please Login or Register  to view this content.

You in the code used 'sheet1' to test sheet name but unfortunately excel tried to hide Sheet1 because 'Sheet1' (sheet name) is different from 'sheet' (lower case).

Regards,
Antonio