Securing Workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Gang:

I would like to secure my Excel 97 (and Excel 2000) workbook from users in
such a way that they can only enter values in a specific range and view the
results in another range. I'd like to keep my formulas and other sheets
hidden from the users. I;'ve been using the Protection properties at the
range, sheet, and workbook level. Unfortunately, as soon as the user saves
the workbook using the Save As method, it appears that all protection is
removed.

Do anyone have any suggestions on how to keep the sheets and workbook
protected when the workbook is saved as another object?

TIA,
Ed
 
You may want to rethink your strategy altogether. There's no way to
protect your workbook the way you want. A user with a moderate amount of
curiosity, and enough technical savvy to find these newsgroups, will be
able to bypass your worksheet protection in about 30 seconds:

http://www.mcgimpsey.com/excel/removepwords.html

The only really secure way to protect your calculations is to put them
in a COM add-in, where they'll be compiled.
 
Back
Top