ExcelBanter - Lock cell shading and size only

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Lock cell shading and size only (https://www.excelbanter.com/excel-worksheet-functions/7589-lock-cell-shading-size-only.html)

fhires

Lock cell shading and size only

I want to lock cell format yet still allow users to input data in each
individual cell. Everything I find under protection also locks the cell from
alpha/numeric input. How can I do this.

Frank Kabel

Hi
AFAIK this is not really possible in Excel

--
Regards
Frank Kabel
Frankfurt, Germany

"fhires" schrieb im Newsbeitrag
...
I want to lock cell format yet still allow users to input data in
each
individual cell. Everything I find under protection also locks the
cell from
alpha/numeric input. How can I do this.

All times are GMT +1. The time now is 08:23 AM.