ExcelBanter - How can I Lock Formatting?

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

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

- - How can I Lock Formatting? (https://www.excelbanter.com/excel-worksheet-functions/65134-how-can-i-lock-formatting.html)

Scott

How can I Lock Formatting?

I would like to be able to lock formatting (specifically borders) then
protect a sheet so that users can drag and only fill values...

Thanks in advance.

Vasant Nanavati

How can I Lock Formatting?

I don't think this can be done; at least not without a fairly complicated
macro.

"Scott" wrote in message
...
I would like to be able to lock formatting (specifically borders) then
protect a sheet so that users can drag and only fill values...

Thanks in advance.

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