Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 12th 05, 02:31 AM
B Fraissinet
 
Posts: n/a
Default How do I give all access to one worksheet but not to other worksh.

I'm using Excel 2003, The 1st worksheet is our project staff schedule the
other 8 are individual's timesheet that feed from the 1st worksheet. I don't
want others within this group to see someone else's timesheet. Is there any
way to grant permissions to an individual to open the schedule (1st
worksheet) and there timesheet without opening anothers worksheet?

  #2   Report Post  
Old January 12th 05, 07:37 AM
Arvi Laanemets
 
Posts: n/a
Default

Hi

Better use a different design, where you have a network resource with
subfolders for every individual (+subfolder for supervisor).

On root of network resource you have shedule worksheet. the folder is
read-only for all users except supervisor, who is managing the shedule.
Each individual has full access to his subfolder, only supervisor has access
(read-only) to others individual subfolders. Each individual has own
workbook with at least 2 sheets - the mirror of shedule from root (through
links), and his/her timesheet.
The supervisor has a workbook with staff shedule and all individual
timesheets mirrored, and maybe some additional sheets for various (summary)
reports. Supervisors workbook may be on special subfolder, or in root folder
(when this is the case, then you can protect it with password for open), or
on supervisors workstation. Moreover - you can have an unlimited number of
supervisor's workbooks - of same or different design, and on different
locations.
With design like this, every user can access his/her workbook at any time
without interfering with other users, because Excel file sharing isn't used
at all.

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"B Fraissinet" <B wrote in message
...
I'm using Excel 2003, The 1st worksheet is our project staff schedule the
other 8 are individual's timesheet that feed from the 1st worksheet. I

don't
want others within this group to see someone else's timesheet. Is there

any
way to grant permissions to an individual to open the schedule (1st
worksheet) and there timesheet without opening anothers worksheet?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copyright and worksheet protection dow Excel Discussion (Misc queries) 2 January 3rd 05 04:07 PM
Indirect reference from one worksheet to another Bill Sturdevant Excel Worksheet Functions 2 December 17th 04 02:23 PM
Reference Data in Moved Worksheet tommcbrny Setting up and Configuration of Excel 1 December 1st 04 07:49 PM
Worksheet name and Backward compatibility Rich Excel Discussion (Misc queries) 3 November 30th 04 07:10 PM
How to call worksheet functions from Access ? Martin Plamondon Excel Worksheet Functions 0 November 18th 04 07:50 PM


All times are GMT +1. The time now is 05:23 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017