Excel 2003 - locking down spreadsheet

  • Thread starter Thread starter Janet
  • Start date Start date
J

Janet

Hello,
Here is my scenario: I have a workbook with 3
spreadsheets - we need to distribute this workbook to
several individuals for their data input, however, WE DO
NOT WANT THEM TO EVER CHANGE anything. We created pull
down menus hoping to avoid the users to enter in any old
text they want. But, we were thinking, if they know how
to use validation rules, they could go in, turn it off,
and write whatever they want. We need to avoid this at
all cost.

We were trying to figure out how to lock down the
spreadsheet to only allow the users to only enter
information that is listed in the pull down menus. Can
this be done?

If so, please explain.

Thanks.
 
Hi
you can of course try to protect your sheet/workbook ('Tools -
Protection). But if they know how to do it, it's nearly no effort to
overcome ALL of Excel's security features
 
Back
Top