Edit call but no formatting

[bimo]

Hi All

I would like users to be able to enter values into selected Cells but not be able to change Formatting ..

Any ideas please ?
Thanks

[Ace_XL]

You would need to protect the sheet

Do this..
- Select desired cells
- Format cells (Ctrl+1) -- Protection -- Uncheck the 'Locked' field -- Ok
- Review -- Protect sheet -- Check 'Select Unlocked cells' -- Uncheck all other fields --Enter a desired password -- Ok

[bimo]

Thank you !