I've got a Workbook report that pulls 'raw' source data in via MS Query. I don't want the report recipients to see this RAW DATA and also some other 'helper' worksheets so I've set those to be VeryHidden. Since there are a large number of other visible sheets, I've copied a macro which produces...
I have some code that will loop a range and copy worksheets.
Each of the sheets with *Data in the name needs to be hidden.
For j = 1 To n
On Error Resume Next
Set Target = Nothing...