Field and Worksheet Restrictions

  • Thread starter Thread starter alvarezrrb
  • Start date Start date
A

alvarezrrb

I have a multiple tab document that I would like to give access to the
users to enter text in some places and number in other fields
throughout the entire document, seperate tabs.


The second thing I would like to do is restrict the entering of data in
any other part of the document. That means that only the fields that I
would like them to into enter data into is available for manipulation.
 
Hi alvarezrrb,

Use Format|Cells|Protection and unlock the cells you want to be able to
enter data into, then use Tools|Protection|Protect Sheet or Protect Workbook
to apply the level of protection you want - the options are explained in
Excel's help file, under 'Protect workbooks and worksheets from changes'.

Cheers
 
Depending on you version of excel, you can select
TOOLS > PROTECTION > ALLOW USERS TO EDIT RANGES

Then select the ranges and then you will see a button that says
PROTECT SHEET
Then select the options and click ok

all done.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Forms, Fields, and Restricted Editing 1
When sharing, can I force an Excel document to open in a certain view? 0
Restrict Choice in Shared WB (drop down alternative)? 0
Access Automatically Send a notification email once a record is added 0
restricted values error message 4
Allowing different users access to different worksheets 1
Macro: finding a cell on one worksheet and copying to another worksheet 0
Refreshing fields in Excel 1

Back
Top