Hi
is it possible to limit the editability of a group of cells (or columns) in a protected shared file?
What I want to do is have a file on the server that sales and production staff can enter ordered materials into. Some cells/columns will be locked so they cannot edit the titles and the autofilled dates (through macros). For the other cells I would like it to be ONLY possible to type the details into the cells or delete what is there.
I am hoping to set up a simple computer in our receivables section purely running this file with no keyboard set-up (mouse only) as all they should need to do is change the "Arrived" column dropmenu to "yes" and maybe clear the content of cell (which triggers a "clear entire row" macro) after the products have been used (and we no longer need the record of whether it has arrived...).
Hope this all makes sence...
Thanks
Patrick
Bookmarks