[quote]Originally posted by Lowland:
<strong>If you don't want to VB script it, simply go Tools>Protection and lock what you want (Sheet, workbook). Password availabiltiy there.
Then on the cells you want to, right-click, FormatCells>Protection (It tells you to do step one above!)

Good luck</strong><hr></blockquote>

Yeah, that's the normal way to lock a spreadsheet. You lock the cells then turn on worksheet or workbook protection. Only unlocked cells can then be altered. Keep in mind that if you do use the VBA script, many of Excel's normal functions like copy and paste don't work anymore. I had the same problem with a spreadsheet I created that used VBA drop-down list boxes to choose what went into a particular set of cells. So, the VBA script was constantly looking to see if a cell was the correct cell for the dropdown list and it overran the normal worksheet functions. I'm in the process of making the dropdown lists an add-in library file (XLA) so that I can get worksheet functionality back...