Multi-User Passwords

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" <[email protected]> a écrit dans le message de
news:[email protected]...
> 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" <[email protected]> a écrit dans le message de
> news:[email protected]...
> > 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
>
>
>