Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2006

Tip: Looking for answers? Try searching our database.

designate cells

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
renee - 05 Jul 2006 19:26 GMT
There is a Excel 2000 workbook at my workplace that is shared among multiple
departments.  The book contains a spreadsheet per patient and our ancillary
staff enters data on the worksheets of the patients that they have seen for
the week.  There are times when a user will accidentally delete another users
data causing that department to have to go back in and replace the data.  How
can I set these sheets up so that if a user is in the wrong area, they will
not be allowed to type?  Can this be done?  What are my options here?
Corey - 05 Jul 2006 19:34 GMT
Using permissions, you can designate which users would be able to
simply look at the file and which users would actually be able to edit
the info contained therein.

On the Standard Toolbar next to the Save button is the permission
button.  Selecting that should allow you to designate which users are
granted what privelages.

Also, you can go into your Tools, Protection, Allow Users to Edit
Ranges and create a 'Read-Only' range of cells by selecting New..., and
listing the cells designated to be read only.

Hope that helps!

> There is a Excel 2000 workbook at my workplace that is shared among multiple
> departments.  The book contains a spreadsheet per patient and our ancillary
[quoted text clipped - 3 lines]
> can I set these sheets up so that if a user is in the wrong area, they will
> not be allowed to type?  Can this be done?  What are my options here?
Trevor Shuttleworth - 05 Jul 2006 22:41 GMT
But ...

Information Rights Management (IRM) in *** Microsoft Office 2003 *** is a
new feature that allows individual authors to specify permission for who can
access and use documents or e-mail messages, and helps prevent sensitive
information from being printed, forwarded, or copied by unauthorized people.
Once permission for a document or message has been restricted with this
technology, the access and usage restrictions are enforced no matter where
the information is, since the permission to access an e-mail message or a
document are stored in the file itself.

IRM in Office 2003 helps corporations and knowledge workers address two
fundamental needs:

 a.. Restricted permission for sensitive information   Most corporations
today rely on firewalls, log-in security, and other network technologies to
protect their sensitive intellectual property. The fundamental limitation of
these technologies is that, once legitimate users have access to the
information, they can share it with unauthorized people, potentially
breaching security policies. IRM helps prevent the sensitive information
itself from unauthorized access and reuse.
 b.. Information privacy, control, and integrity  Information workers often
deal with confidential or sensitive information, relying on the discretion
of others to keep sensitive materials in-house. IRM eliminates the
temptation to forward, copy, or print confidential information by disabling
those functions in documents and messages with restricted permission.
> Using permissions, you can designate which users would be able to
> simply look at the file and which users would actually be able to edit
[quoted text clipped - 23 lines]
>> will
>> not be allowed to type?  Can this be done?  What are my options here?
Corey - 05 Jul 2006 19:35 GMT
Using permissions, you can designate which users would be able to
simply look at the file and which users would actually be able to edit
the info contained therein.

On the Standard Toolbar next to the Save button is the permission
button.  Selecting that should allow you to designate which users are
granted what privelages.

Also, you can go into your Tools, Protection, Allow Users to Edit
Ranges and create a 'Read-Only' range of cells by selecting New..., and
listing the cells designated to be read only.

Hope that helps!

> There is a Excel 2000 workbook at my workplace that is shared among multiple
> departments.  The book contains a spreadsheet per patient and our ancillary
[quoted text clipped - 3 lines]
> can I set these sheets up so that if a user is in the wrong area, they will
> not be allowed to type?  Can this be done?  What are my options here?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.