View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
darknailblue
 
Posts: n/a
Default Shared Workbook Access?


Hi... we have a work log at work (obviously) and I was wondering if it
is at all possible to set up the workbook so each individual user can
edit in his/her assigned worksheet ONLY!! Ideal scenario I want is
that we can all edit this shared file but only edit our assigned
worksheet (designated by our name) and only see our deginated worksheet
and not everyone elses. The global editing priviledge for all users is
starting to cause problems such as people not paying attention and
entering work on other people's sheets or psycho people deleting other
people's work and whatever else could possibly occur.

If its possible to set something up like that would it also be possible
to have someone with 'administrative' priviledges edit and view the
entire content of the workbook so that they can for instance print
reports on our daily and weekly totals or whatever else they need to
do?

~darknail

esteemed n00b


--
darknailblue
------------------------------------------------------------------------
darknailblue's Profile: http://www.excelforum.com/member.php...o&userid=33580
View this thread: http://www.excelforum.com/showthread...hreadid=533568