Locking Format for Certain Cells

[mizeu]

I have a spreadsheet that I pass around for others to fill out but they keep changing the format of certain cells from General to Text and it messes up some of my formulas. Is there anyway to lock these cells so that they stay General format and cannot be changed?

 

[GerryZ]

Hello
As I know you have to do it mannualy, or if the cells ara always the same you can make a VBA code that retrive always the same format
Bye

 

[mizeu]

Hello
As I know you have to do it mannualy, or if the cells ara always the same you can make a VBA code that retrive always the same format
Bye

That's a nice idea, I hadn't thought of that. So am I right to assume that it is the only way around the issue and you can't lock cell formats?