But it is still bad Pascal that they have changed a constant value over
versions. I always warn people about using the RIGHT constant for this very
reason, but never really expected it to happen. (I also used to warn people
to use Rows.Count rather than 65536, but again I didn't really think that MS
would ever increase the number of rows. Guess I am not much of a sage :-))
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"papou" wrote in message
...
Hello Bob
Our friend was trying "xlveryhidden" which obviously could not work if I
understood his message correctly.
Now my mistake as regards versions.
Cordially
Pascal
"Bob Phillips" a écrit dans le message de news:
...
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