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.