Spreadsheet Protection

  • Thread starter Thread starter Sheldon
  • Start date Start date
S

Sheldon

How do you protect a spreadsheet/workbook so that the user
cannot display the toolbars, the grids, the column and row
labels and the sheet tabs? Also, How can I prevent the
user from unprotecting a sheet? I remove all these
programmatically when the sreadsheet is opened.

Thanks
 
How about go to Tools then Protection and Protect the
sheet and the workbook and protect them both with
passwords?
 
I tried that. The Excel programs opens maximized, but the
worksheet opens between max and min. I can't seem to
maximize the sheet.
Sheldon
 
You can try to throw up roadblocks, but as long as the user can open the
file (file protection is fairly strong with a strong password), and has
gumption enough to find these newsgroups, the user can bypass any
workbook or worksheet protection you put up.

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

If you do decide to use VBA to disable toolbars, etc., make sure you
restore them when another workbook is activated. There's little that
aggravates me more than when a developer changes *my* environment.
 
Back
Top