how do I lock formulas, but still allow rows to be added or delet.

E

ericaamousseau

I can't find my previous question. I want to lock just the formulas. I
still want to be able to add or delete rows and be able to adjust row height.
Any suggestions?
 
R

ryguy7272

Tools > Protection > Protect Sheet
Then, choose what you want the user to do or not do.


Regards,
Ryan--
 

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

Insert row with a locked cell 1
Locking Worksheets, Copy and Paste Question 3
Can't delete file 3
Deleting Rows Containing Protected Cells 2
delete row formula changes array range on related sheet 8
allow insert rows = false for only some of the worksheet 1
Selecting rows. 3
Locking a Spreadsheet but allow inserting 5

Top