Hide or Un-hide sheets based on selection using VBA in Excel

This is a most common question asked across the Groups. How to Hide or Unhide Sheets based on Selection. There are two ways

1 .by pressing a button Macro executed and you can see the hide or un-hide Another option just to select the sheet and automatically the sheet is either hidden

2.Another option just to select the sheet and automatically the sheet is either hidden or un-hidden