View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Alan Smith Alan Smith is offline
external usenet poster
 
Posts: 28
Default 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