How can I Lock Formatting?

G

Guest

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.
 
V

Vasant Nanavati

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is it possible to lock-in or freeze formatting? 3
How do I lock ONLY the formatting on an excel sheet? 2
How do I lock the formatting of my worksheet but still add text? 2
How to lock worksheet formatting? 1
Product Suggestion: lock border and cell formatting only 2
how to lock worksheet formatting? 3
locking formulas in Excel 2007 so users can't change but can vieworiginal formula? 1
Excel Can you lock the value of a cell but not the format? 1

Top