Oh that is awful! In XP, xlsheethidden returns 2, in 2003 it returns 0.

I don't get that at all. I get:

Excel 2000
----------------------
xlHidden = 0
xlVeryHidden = 2
xlSheetHidden = 0
xlSheetVeryHidden = 2

Excel 2002
----------------------
xlHidden = 0
xlVeryHidden = 2
xlSheetHidden = 0
xlSheetVeryHidden = 2

Excel 2003
----------------------
xlHidden = 0
xlVeryHidden = 2
xlSheetHidden = 0
xlSheetVeryHidden = 2

Excel 2007
----------------------
xlHidden = 0
xlVeryHidden = 2
xlSheetHidden = 0
xlSheetVeryHidden = 2

These are as expected.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)



"Bob Phillips" wrote in message
...
Oh that is awful! In XP, xlsheethidden returns 2, in 2003 it returns 0.
Shame on them.

I wonder what xlsheethidden applies to?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"papou" wrote in message
...
Hello Steve
With Excel 2003 (you don't mention your version):
xlSheetVeryHidden

You could also check the correct value for your sheet via the Property
window in the VBA Editor.

HTH
Cordially
Pascal

"K1KKKA" a écrit dans le message de news:
...
Hi all,


Am at a loss here, upon opening my workbook i want a sheet to be
veryhidden, so as not to appear in the Fromat,sheet,unhide, list of
hidden documents.


was using the following code, but alas am getting the message below
the code


CODE

Sub Workbook_open()
Worksheets("Plan").Activate
Sheets("payroll").Visible = xlveryhidden
End Sub


ERROR MESSAGE

Compile error in hidden module: thisworkbook


HYCH



Steve