Answers for "Excel VBA hide sheets with names in array"

VBA

12

Excel VBA hide sheets with names in array

Sheets(arr).Visible = False

'Note1: For this to work without an error, 'arr' needs to be a 1D array with a 
'       valid and actual sheet name in each element.

'Note2: An array cannot be used to make sheets visible if they are hidden.
'       This array technique only works to hide visible sheets.

Posted by: Guest on October-29-2020

Source

Code answers related to "Excel VBA hide sheets with names in array"

Code answers related to "VBA"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#