Multiple Passwords to open worksheets
 

When using the require password to open file option, is it possible to have
more than one password allowed? i.e. individual users and an administrator..
If so, how?
Thanks in advance
--
Rock

Multiple Passwords to open worksheets
 

There is no support for it.

--
Regards,
Tom Ogilvy


"rockflier" wrote in message
...
When using the require password to open file option, is it possible to
have
more than one password allowed? i.e. individual users and an
administrator..
If so, how?
Thanks in advance
--
Rock

Multiple Passwords to open worksheets
 

Tom,
This is what I feared. It never hurts to ask the pros. Thanks!!
--
Rock


"Tom Ogilvy" wrote:

There is no support for it.

--
Regards,
Tom Ogilvy


"rockflier" wrote in message
...
When using the require password to open file option, is it possible to
have
more than one password allowed? i.e. individual users and an
administrator..
If so, how?
Thanks in advance
--
Rock

Multiple Passwords to open worksheets
 

This is what I feared. It never hurts to ask the pros. Thanks!!

You can always try to combine 2 options (or rather by-passes, but it's more
than nothing):

1. Use different passwords to open read-only, and to open for writing.
2. Generate multiple versions of one workbook, with different passwords, for
each user - you can very simply do it, using VBA.

Multiple Passwords to open worksheets
 

Tomasz,
Being a relative neophyte, I do not understand how to exercise either
option. Perhaps you could expand. Thanks in advance.
--
Rock


"Tomasz Klim" wrote:

This is what I feared. It never hurts to ask the pros. Thanks!!

You can always try to combine 2 options (or rather by-passes, but it's more
than nothing):

1. Use different passwords to open read-only, and to open for writing.
2. Generate multiple versions of one workbook, with different passwords, for
each user - you can very simply do it, using VBA.

Multiple Passwords to open worksheets
 

Tomasz,
I see how the read only and write password option works. Thanks. As for the
VBA, I do need some help there. Thanks again.
--
Rock


"Tomasz Klim" wrote:

This is what I feared. It never hurts to ask the pros. Thanks!!

You can always try to combine 2 options (or rather by-passes, but it's more
than nothing):

1. Use different passwords to open read-only, and to open for writing.
2. Generate multiple versions of one workbook, with different passwords, for
each user - you can very simply do it, using VBA.