Hi!
If you used the option buttons:
Right click each button
Select Format Control
Protection tab
Make sure Locked is selected
Now, to protect the worksheet:
Select the entire sheet
Goto Format>Cells
Protection tab
Make sure Locked is selected
OK
Now, select the cells that you want the users to be able to enter data in
*AND* the linked cell for the option buttons.
Goto Format>Cells
Protection tab
Uncheck Locked
OK
Goto Tools>Protection>Protect Sheet
Depending on which version of Excel you are using, there will be various
options for setting protection. Choose the ones you want.
Also it is possable to disable the save option? on just this document???
That would require more VBA programming. I don't know how to do that
specifically so you should ask that question in a new post.
Biff