Variations in a sheet's Visible status
 

At one time, wasn't it possible to set a tab in a workbook to something
like "HopelesslyHidden"? That's pinging in my memory but I can't find
anything about it. I'm seeing hidden named ranges that refer to tabs
in this workbook, but the tabs are not Hidden or VeryHidden.

Variations in a sheet's Visible status
 

You're right, it is xlVeryHidden

--
kassie

never stop learning
"Dave O" wrote in message
oups.com...
At one time, wasn't it possible to set a tab in a workbook to something
like "HopelesslyHidden"? That's pinging in my memory but I can't find
anything about it. I'm seeing hidden named ranges that refer to tabs
in this workbook, but the tabs are not Hidden or VeryHidden.

Variations in a sheet's Visible status
 

xlsheetveryhidden?

You have to use it in code or via the properties window for that sheet.

Dave O wrote:

At one time, wasn't it possible to set a tab in a workbook to something
like "HopelesslyHidden"? That's pinging in my memory but I can't find
anything about it. I'm seeing hidden named ranges that refer to tabs
in this workbook, but the tabs are not Hidden or VeryHidden.

--

Dave Peterson