In principle it should be fairly easy to do something like that by looking at
the currently logged in user name, and then hiding all the worksheets except
those that a particular user needs.
If I was writing this application I would use the following procedure to to
what you want.

1. Create the workbook you want, and hide all the sheets.
2. Put some code in an Auto_exec macro that checks for the current user name.
3. When the current user name is known, unhide only the worksheets they need.
4. On the Workbook close event hide all sheets again.

There is a small piece of code on my website at www.nwarwick.co.uk that will
get the user name for you.

Points to note a
1. Only one user can use the workbook at anyone time - if you need
simultaneous multi-user access then a database such as MS Access will
probably be better.
2. There is still nothing to stop people entering eroneous data.
3. The whole thing will totally fall down if the user has 'High' macro
security or chooses not to run macros.
4. You will need to consider locking out ant menu bar entries that might
allow users to by bypass your security.

That should give you some things to work on / think about for a while

Neil
www.nwarwick.co.uk

"darknailblue" wrote:


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