I have several worksheets w/ fields that display information and allow user
input in a couple of areas on each sheet. Each as macro buttons the user
pushes after his input to update another database worksheet. How do I lock
the entire db worksheet and all columns on the other sheets except the ranges
user input is allowed. The macros need to be able to update data in the
locked areas of any sheet.