How do I allow users to fill down on a protected sheet?

  • Thread starter Thread starter AOEO
  • Start date Start date
A

AOEO

I'm trying to set up a workbook on our network for users to enterdata on,
however the sheet needs to be protected. Even if I turn all of the
"priviledges" on (give them to the users) in the protection choices, I can't
get it to fill down, which will be very important for our users to be able to
do.

Am I missing something?
 
Hi,
you can protect you workbook and have the cells where the users enter data
unprotected
Highlight the cell where the data will be entered and then right click in
the mouse, format cells, Protection , uncheck locked. then protect your
workbook
other option will be to set up a password for users to enter to be able to
open the sheet
 
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

hide columns on a protected sheet??? 1
password protect allowances 1
Protecting sheets with drop down boxes 6
Edit/Fill/Series on Protected Sheet 1
Trace dependants or Precedents on a protected sheet 1
allow merging cells in protected sheet 1
Allow user to insert rows on protected worksheet 1
Can I protect data in a cell, but allow comments to be entered. 6

Back
Top