Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deactivate autofill
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 -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deactivate autofill
You have a few replies at your other posts.
"sowetoddid <" wrote: 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. --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deactivate Save As | Excel Discussion (Misc queries) | |||
Deactivate worksheet | Excel Discussion (Misc queries) | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
Deactivate web toolbar | Excel Discussion (Misc queries) | |||
Deactivate Formula | Excel Programming |