designate cells

R

renee

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

Corey

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!
 
C

Corey

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!
 
T

Trevor Shuttleworth

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.
 
Top