Deactivate autofill

  • Thread starter Thread starter sowetoddid
  • Start date Start date
S

sowetoddid

I have a block of about 500 cells that require text input (mainl
numbers, but also some plain text). I would like the user to only b
able to input the assigned values one at a time without alterin
anything else.

Right now the entire spreadsheet is password protected with th
exception of these 500 cells. However, I have found that the autofil
and "drag and drop" have allowed users to modify the formating on th
sheet.

How can this be prevented?

I also deactivate drag and drop, and that only deactivates the comman
on cells that are protected. Please help
 
You have a few replies at your other posts.

sowetoddid < said:
I have a block of about 500 cells that require text input (mainly
numbers, but also some plain text). I would like the user to only be
able to input the assigned values one at a time without altering
anything else.

Right now the entire spreadsheet is password protected with the
exception of these 500 cells. However, I have found that the autofill
and "drag and drop" have allowed users to modify the formating on the
sheet.

How can this be prevented?

I also deactivate drag and drop, and that only deactivates the command
on cells that are protected. Please help.
Click to expand...
 
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

Sheet Deactivate Loop 2
Prevent drag copy 3
how can deactive cells to input data 1
Autofill destination incrementing date by 1...don't want it to 3
Hyperlinks fail when constructed using Autofil 2
Applying autofill macro that covers multiple sheets/columns 4
Deactivate Code 2
Autofill macro - variable destination cells 7

Back
Top