Hello,
I am trying to design a form for my work which is to be circulated around the whole business. Essentially I want people to be able edit the content of cells without being able to edit the format. For example, one cell will need a number entered that will always begin with a 0. Creating that is not a problem, but if the format of the cell is edited, and the number is displayed without the 0 at the front it will be a pain as our system will not recognise the number without the 0. I'd like to be able to circulate this form safe in the knowledge that nobody else can change the format, but can still edit the text/numbers in required cells.
Can anybody help as I've run out of ideas!
Bookmarks