Multi-User Passwords

[Guest]

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

 

[Ardus Petus]

This could be done with VBA macro code

 

[Guest]

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.