Hide And Unhide Sheet. Using a simple vba code can automate this task for you. Hidden sheets can be seen by right clicking in the worksheet tab area.
The above code loops through all the sheets of the workbook then match each sheet s name with the active sheet s name and hide it if it doesn t match. To unhide a sheet in vba use the worksheet visible property. Below is the vba code that will hide all the worksheets except the current active worksheet.
The above code loops through all the sheets of the workbook then match each sheet s name with the active sheet s name and hide it if it doesn t match.
Hide unhide worksheets using vba. Using a simple vba code can automate this task for you. Below is the vba code that will hide all the worksheets except the current active worksheet. Hidden sheets can be seen by right clicking in the worksheet tab area.
