Lock information

  • Thread starter Thread starter slaga
  • Start date Start date
S

slaga

I have created a form template
I want to lock all the cells that already have information in them,
but leave the blank ones available for the user to enter and edi
information.
is this possible
 
Possible.....yes.

By default when you protect the sheet under Tools>Protection>Protect Sheet, asll
cells are locked.

If not too many cells with data in them, you can lock them and leave all others
unlocked.

CTRL + a(twice in 2003) to select all cells.

Format>Cells>Properties. Uncheck "locked" and OK

Select the cells with data and Format them to "locked".

Now protect the sheet.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

Excel Can you lock the value of a cell but not the format? 1
Using fields in a locked template 5
Record-Locking remains open after closing 0
Export Data from another source to use in an excel template 0
Cell Locking Question 2
Clear Contents 5
Access Cannot select items in listbox 1
Can you mail merge information from protected Excel sheet? 1

Back
Top