Stop font type, colour, size etc?

[tazmanian24]

Hi All,

Having just had some superb help from Romperstomper I'm after some more!!!!

Basiccaly, long story short, I have a spreadsheet going out daily....everyday it comes back someone has managed to muck something up even though it is protected.

I want the sheet to only allow entering data!

I have sorted no right click and edit menu deactivations with Romperstompers help, but can I stop everything else basically?

Also I want the cells to allow limited entry in length, so if it asks for a name it can take say 15 letters max?

THANKS IN ADVANCE if someone can

[romperstomper]

You can limit the data entry length using data validation (use the Text Length option in the Allow dropdown). For the formatting, that's an option you can turn off in the protection settings.

[tazmanian24]

SO easy when you know how!!!

Thanks again, much appreciated