sheet and workbook protection

  • Thread starter Thread starter Laundone
  • Start date Start date
L

Laundone

Can you protect a sheet and workbook so that rows, columns and formulas
cannot be changed, but others can add data (filling cells with data)
 
All cells are locked by default, but locking does not mean anything until
you protect the worksheet from Tools>Protection menu.

--First select any cells that a user is allowed to change
--Hit Ctrl + 1 and go to the 'Security' tab to unlock these cells.
--Go to Tools->Protection->Protect Sheet, and you can assign a password
(optional)


If this post helps click Yes
 

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

Protect Worksheet to share with older versions of excel 2
Excel Protection 2
Excel Move or Copy Stopped Working? 0
Sharing workbooks limitations - Merged Cells 12
Attempted edit of protected cell jumps user to another cell 2
Merge Multiple workbook sheets into one workbook 0
Protect & Hide Sheet 3
Formula Audit mode active in one column only; cannot kill. 2

Back
Top