Protecting worksheets

[Flowered Up]

Hi there!
I have an excel workbook with 8 worksheets (1 for each of
my bosses). Rather than emailing each guy a copy of the
file every month for completion then having to merge the
data back into 1 workbook, I want to send them a link to a
file, saved in a shared area and let them each complete
their bit.
The problem is the sensitivity of the information - I only
want each boss to have access to their worksheet. I'm
thinking along the lines of password protecting each sheet
seperately with a different password - is this feasible or
practical?

Any tips / hints / advice gratefully received.

 

[icestationzbra]

i had a similar requirement. i had 18 different users who had thei
separate logins. the only issue that i found was that, the level o
security you can provide that way is greater with excel 2002, a
compared to excel 2000. there is another thing you need to take car
of. the user access can be provided only through VBA macro, if someon
disables macros while opening the files, then the security can easil
be breached. but, there is a workaround for that too, it involve
making macros mandatory.

however, you need to remember one thing, excel does not provide th
greatest security. an excel savvy user can circumvent these with
little bit of effort.

if you still think that this is the way to go for you, you could fin
appropriate resources on this forum. i could provide you with some o
the code i have written

 

[Arvi Laanemets]

Hi

For similar occassions I use a design with a separate workbook, situated on
some network resource, for every user. The data from user's workbooks are
collected into master/consolidation workbook(s), situated on PC('s) or on
network resource, through links (master workbook will be slower because a
lot of formulas, but all changes are refreshed whenever calculation is
fired, p.e. when you activate the sheet), or through ODBC queries (no link
formulas, it works much faster, but you have to force data refreshing - I
usualy use refreshing on open). When there are some common data, managed
centraly, then in users workbooks they are accessed through links or queries
too (when this is the case, the master or special source workbook has to be
on some network resource, accessible for all users).

Why do I prefer this:
1. All users can access their data at any time. No read-only issues anymore.
2. Every user has access only to his own data. You can't use Excel's
password protection because links/queries, but server-level protection will
do much better anyway.
3. You can have unlimited number of master workbooks - of same or diferent
design.
4. You can design user's workbooks as databases - with personally designed
features like charts, statistics, report sheets etc.
5. It's enough for start.