Locked cells in Excel

  • Thread starter Thread starter Dave P.
  • Start date Start date
D

Dave P.

When I lock even just a few cells in Excel, it seems that functions such as
AutoSum, Copy, etc. stop working. What do I need to do to just prevent the
inadvertant entry of data into cells with formulas but still have everything
else work as normal?
 
I don't think that there's anything that you can do to have everything else
(that's a bigggggggggg list) work as normal.

Lots of features are disable when the worksheet is protected.

You may be able to get around some of these restrictions by having a macro that
does what you want, but first checks to see if it's ok to continue, unprotects
the sheet, does what you want, and then reprotects your sheet.

But if your list of things to support is really longggggggg, you may find it's
not worth the trouble.
 

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

autosum 1
Excel - prevent someone from clicking into certain cells 1
Data copy locks cell in worksheet 3
how to protect cells? 4
Locked Property off, but cannot select cell 3
corrupted formula in protected worksheet 21
copy cells but lock editing 5
Locked cells in Excel 2000 1

Back
Top