I guess the OP could start the workbook with the group of sheets hidden and
the workbook password protected. Then, when the workbook is opened, he could
check to see if it is read-only or not... if it is not read only, he could
unhide those sheets. When the workbook is closed, he could re-hide the
sheets and re-apply the password protection. I guess to stop anyone from
discovering the embedded password, he would have to come up with an
encryption/decryption algorithm to make it harder to figure out what the
password is.

--
Rick (MVP - Excel)


"Dave Peterson" wrote in message
...
Ps. The user will have to allow macros to run for those to work.

Craig wrote:

Hi

When a user opens my file they see the standard password box in which
they
can either click the Read Only button and work in it as Read Only or
enter
the password and work in it with write access.

Is there macro code I can enter in the same file that would hide a group
of
worksheets if the user opens that file with write access but would not
hide
these worksheets if they open the file as Read only?

thank you very much.....Craig

--

Dave Peterson