Protecting 50 Sheets in 1 Workbook

[RayD]

Hello everyone,


I am pretty sure this issue has been kicked around, but is there a way
to quickly password protect 50 sheets within one workbook? I have two
columns that have formulas and what those protected.

...

 

[pfsardella]

AKAIK, you need to do this with code. Here are a few solutions.

http://www.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&safe=off&th=fa17861a2dc9461a&rnum=3

If you're not familiar with using VBA, then David McRitchie has a good
introduction on this subject.

http://www.mvps.org/dmcritchie/excel/getstarted.htm

HTH
Paul

 

[Ken Macksey]

Hi

Email me and I will send you a sample workbook that does what you want.

Ken

 

[RayD]

Thanks Paul... I'll give it a try.

AKAIK, you need to do this with code. Here are a few solutions.

http://www.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&safe=off&th=fa17861a2dc9461a&rnum=3

If you're not familiar with using VBA, then David McRitchie has a good
introduction on this subject.

http://www.mvps.org/dmcritchie/excel/getstarted.htm

HTH
Paul