Hide Or Show Worksheets Or Workbooks

Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.

Hide Or Show Worksheets Or Workbooks. You can later select Unhide All Sheets if needed. Just use the code below or something similar.

How To Make The Worksheet Very Hidden And Visible In Excel Excel Tutorials Excel Excel Formula
How To Make The Worksheet Very Hidden And Visible In Excel Excel Tutorials Excel Excel Formula from www.pinterest.com

See this answer to the same question which just minimizes the current workbook. If you want to interact with other worksheets in the background the userform needs to be in Modeless mode. You can later select Unhide All Sheets if needed.

In the VB Editor in the project explorer in VB Editor select the worksheet you want to hide.

Right-click on any of the worksheet tabs. See this answer to the same question which just minimizes the current workbook. The tab is removed but not permanently deleted. To hide a single workbook use.