Multiple Worksheet protection

K

K. Georgiadis

I will need to protect with a password some 50 worksheets
in a workbook, preventing the users from overriding
formulas and hard-coding numbers in calculated fields. It
is my understanding that I cannot accomplish my objective
with workbook protection.

Is there any way to avoid going through the protection
process one sheet at a time? (I noticed that, when I
group the sheets, the sheet protection feature is
disabled).

Is it possible to have a VBA procedure that completes the
entire protection process, including entering the
password twice? If so, I would obviously erase the VBA
code after I'm done, so that the user couldn't discover
the password
 
G

Guest

I presume that the string "drowssap" represents the
password and that it can be replaced with a different
password (one that I am planning to divulge to only one
of the potential workbook users).

Thank you for your help!
 
K

K. Georgiadis

Thank you. On your website your description of how to
protect grouped sheets is obscured by the "Links" box on
the upper right corner of the page. Would you be able to
let me have a copy of the complete text that precedes the
VBA code?
 
J

JE McGimpsey

Yeah, it's a bug in WinIE's rendering engine. I've tried to rewrite the
stylesheet to work with WinIE, but it just doesn't render floating
sections correctly (Mozilla, Opera, Firefox, all Mac browsers, including
MacIE, etc., do).

I've occasionally tried tweaking the CSS to work for IE6, but
accommodating MS's browser bug is not that interesting to me, and
changing it so that WinIE works will break compliance with W3C standards
unless I eliminate the right-hand pane altogether.

You can always see the complete text by right clicking the page and
choosing View Source.
 
Top