S
Shaggyjh
How can i stop someone entering a %age into a protected cell? Is data
validation the only way?
The spreadsheet i thought was fool proof (shouldn't assume i guess!)
Someone has entered 5% into a cell that should read 5, and now all linked
cells are wrong, and 'the someone' can't change the format as i have
protected the sheet.
There is a master spreadsheet that everyone is using, so i could edit this
to hopefully stop this problem happening again!
Many thanks,
validation the only way?
The spreadsheet i thought was fool proof (shouldn't assume i guess!)
Someone has entered 5% into a cell that should read 5, and now all linked
cells are wrong, and 'the someone' can't change the format as i have
protected the sheet.
There is a master spreadsheet that everyone is using, so i could edit this
to hopefully stop this problem happening again!
Many thanks,