Excel Protection?

**demon8991** · 11-26-2009, 05:53 AM

Morning All,

I have a large workbook with lots of spreadsheets, currently each individual sheet is protected as certain cells are locked on each sheet. Rather than having everysingle sheet protected is there a way to lock and protect them all at once?

Thanks

**DonkeyOte** · 11-26-2009, 05:57 AM

Not manually or as a "group" no. You could use VBA sub routine to protect/unprotect all sheets by means of iteration if that's what you're getting at ?

**demon8991** · 11-26-2009, 06:03 AM

Yer that could work will that need a formula for each page or just one page of formula for the whole thing?

**DonkeyOte** · 11-26-2009, 06:15 AM

It would require VBA - not formulae - is that viable in your environment ?

**demon8991** · 11-26-2009, 06:52 AM

Yer that is very feasable, each sheet has some VBA code that i have used.

**DonkeyOte** · 11-26-2009, 07:35 AM

Assuming all sheets have the same password (this is the implication) then something like the below, pasted into a new Module, should do what you want

Please Login or Register  to view this content.

You will find a variety of approaches on line which do similar things... the above is designed to ape the native functionality in so far as if protecting your must reaffirm the password chosen etc...