Re: Protecting 50 Sheets in 1 Workbook

Giganews Newsgroups
Subject: Re: Protecting 50 Sheets in 1 Workbook
Posted by:  pfsardel…@yahoo.com.nospam
Date: Thu, 16 Oct 2003

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
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

>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.
>
>..

Replies

In response to

Protecting 50 Sheets in 1 Workbook posted by RayD on Thu, 16 Oct 2003