Is there a way to set up an excel spreadsheet, requesting a password to open,
but the password used will determine the data that can be seen by the user.

For example I have set up some sales tools that show performance at various
hierarchial levels:- national, regional, territory. I would like those people
with national access to be able to view all data, regional access to just
view their region and the territories in that region, and territory access to
just view their territory.

Thanks

Graham

This could be done with VBA macro code

--
AP

"gparkins" a écrit dans le message de
...
Is there a way to set up an excel spreadsheet, requesting a password to
open,
but the password used will determine the data that can be seen by the
user.

For example I have set up some sales tools that show performance at
various
hierarchial levels:- national, regional, territory. I would like those
people
with national access to be able to view all data, regional access to just
view their region and the territories in that region, and territory access
to
just view their territory.

Thanks

Graham

an if the user disables macros, then the VBA macro code would have no effect.
since any type of protection in Excel is easily broken, you would be better
to use VBA to prepare separate workbooks for each party that contains only
the data they can see.

--
Regards,
Tom Ogilvy


"Ardus Petus" wrote:

This could be done with VBA macro code

--
AP

"gparkins" a écrit dans le message de
...
Is there a way to set up an excel spreadsheet, requesting a password to
open,
but the password used will determine the data that can be seen by the
user.

For example I have set up some sales tools that show performance at
various
hierarchial levels:- national, regional, territory. I would like those
people
with national access to be able to view all data, regional access to just
view their region and the territories in that region, and territory access
to
just view their territory.

Thanks

Graham