I appreciate all the tips and help with the issue of not
having a basic xlVeryHidden statement actually hiding the
worksheet. Just as an FYI should you run into it again,
the issue was to unprotect the workbook, run the command,
and protect the workbook again. Seems that command will
not work with protection on (or at least it didn't in my
case - YMMV)

kpd

Protecting the workbook has two options: Structure and Windows. Protecting
the structure means that you can't change sheet names, move sheets or
otherwise alter the structure of the workbook, such as hiding sheets. So
this behavior shouldn't come as a surprise. What was your purpose in
protecting the workbook?

--
Regards,
Tom Ogilvy


"kevin" wrote in message
...
I appreciate all the tips and help with the issue of not
having a basic xlVeryHidden statement actually hiding the
worksheet. Just as an FYI should you run into it again,
the issue was to unprotect the workbook, run the command,
and protect the workbook again. Seems that command will
not work with protection on (or at least it didn't in my
case - YMMV)

kpd