Vba Hide Sheets When Closing File. Selecting multiple worksheets groups them together; the word [Group] appears after the file name in the title bar. I need some script that will automatically hide sheet x when I close the file.
When the users close the document all sheet should "disappear" again. VBA - Hide (or Unhide) a Worksheet. The following Excel VBA macro displays the active sheet index number in a message box.
VBA - Hide (or Unhide) a Worksheet.
When the "Next ws" line of code is hit, the macro jumps back up to the first line of code within the loop and evaluates it again.
Click on a sheet, hold down the control or the shift key, click on the other sheets you'd like to hide, right-mouse click and select A fully-functional, ready to use VBA solution to unhiding selected sheets has been gifted to us by Daniel. Hide all sheets except active one with VBA. Download the file that contains the macro.