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?
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?