software

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

quot;gparkinsquot; gt; a écrit dans le message de
...
gt; Is there a way to set up an excel spreadsheet, requesting a password to
open,
gt; but the password used will determine the data that can be seen by the
user.
gt;
gt; For example I have set up some sales tools that show performance at
various
gt; hierarchial levels:- national, regional, territory. I would like those
people
gt; with national access to be able to view all data, regional access to just
gt; view their region and the territories in that region, and territory access
to
gt; just view their territory.
gt;
gt; Thanks
gt;
gt; 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 Ogilvyquot;Ardus Petusquot; wrote:

gt; This could be done with VBA macro code
gt;
gt; --
gt; AP
gt;
gt; quot;gparkinsquot; gt; a écrit dans le message de
gt; ...
gt; gt; Is there a way to set up an excel spreadsheet, requesting a password to
gt; open,
gt; gt; but the password used will determine the data that can be seen by the
gt; user.
gt; gt;
gt; gt; For example I have set up some sales tools that show performance at
gt; various
gt; gt; hierarchial levels:- national, regional, territory. I would like those
gt; people
gt; gt; with national access to be able to view all data, regional access to just
gt; gt; view their region and the territories in that region, and territory access
gt; to
gt; gt; just view their territory.
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt; Graham
gt;
gt;
gt;