| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I open multiple worksheets each in its own tab | Excel Discussion (Misc queries) | |||
| I want to open multiple new worksheets | New Users to Excel | |||
| Open multiple files into multiple worksheets of the same workbook | Excel Discussion (Misc queries) | |||
| different passwords for each worksheets | Excel Worksheet Functions | |||
| Apply passwords to open on multiple files | Excel Programming | |||
Hybrid Mode
