Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 427
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 37
Default 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.



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Visual Basic: Compile error: Sum or Function not defined Dmitry Excel Worksheet Functions 12 April 3rd 06 07:28 AM
insert Rows with Formulas in Place on Multiple Sheets? Michael Link Excel Discussion (Misc queries) 5 March 9th 06 01:54 PM
3 sheets in workbook, but visible only one? slaya_cz Excel Discussion (Misc queries) 3 September 30th 05 01:37 PM
Finding specific sheets within a workbook Roy Excel Discussion (Misc queries) 2 August 23rd 05 06:40 PM
Multiple sheets selected twa14 Excel Discussion (Misc queries) 2 December 21st 04 11:15 AM


All times are GMT +1. The time now is 02:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"