i created a file for sharing, it contains functions such as dependant lists. I need to prevent ppl from copy and pasting into the columns which containing the lists.
and there are monthly sheets of similar data.
and because there are old managers who need to use this file, they don't like anything complicated.
is there any other way of setting this thing up, so it allows them add entries, delete enties, and sort and share, at the same time for some columns it has restricted selection of contents?
prefer not to use VB.
i spent too much time on this crap le..