Locking worksheet labels and box sizes

  • Thread starter Thread starter Munchkin
  • Start date Start date
M

Munchkin

I made an application in Excel 2007 for my clients to fill out with drop down
boxes. I want to be able to lock the size and the labels on the application,
but still let me clients use the drop down boxes and type in informaiton in
appropriate places. Everytime I try to lock it locks the whole sheet so they
can't use the drop down boxes.
 
I made an application in Excel 2007 for my clients to fill out with
drop down boxes. I want to be able to lock the size and the labels on
the application, but still let me clients use the drop down boxes and
type in informaiton in appropriate places. Everytime I try to lock it
locks the whole sheet so they can't use the drop down boxes.
Click to expand...

by default, all cells are check marked as "locked"
- right click on your cell (or range of cells)
- click format cells...
- the last tab is protection
- just uncheck the unlock

then when you go back into protect the sheet, you want to uncheck unlocked
cells.
hope that helps
 
Back
Top