Restrict Access upon Opening?
Hi all,
I am looking to create a workbook to track salaries and changes for the
company, with the ability for each manager to open it and update the relevant
details. What I would like, though, is a way to restrict the access so that
each manager can only see his/her team.
Is it possible to create a type of "log in" when the file opens, and have
that determine the available records? Can I utilize the security functions to
limit viewable access? Is there a better/easier way? All comments appreicated.
Regards,
Alan
|