sheet and workbook protection

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)
 
J

Jacob Skaria

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
Sharing workbooks limitations - Merged Cells 12
Locking cells in a shared workbook 2
hide columns on a protected sheet??? 1
Paste Values in linked Cells Only 4
Excel A CountIF question... I think 2
problems getting this macro to work 23
Excel Move or Copy Stopped Working? 0

Top