Hi, Diddy!

I am not sure I get this. Here is my problem. I have 20 sheets in my
workbook that I need to protect but at the same time allow users to edit
range "C2:C30" in each one of these sheets. I don't want to go into every
sheet and manually do "allow users to edit range" 20 times. What would the
macro be to do all at once?

Thanks,
EugeniaP

"Diddy" wrote:

Hi EugeniaP,

Once you have unprotected the ranges you want to be able to edit in Format
Cells Protection then you can use the code on this page
http://www.ozgrid.com/VBA/excel-macr...cted-sheet.htm under
UserInterFaceOnly which allows you to run other macros at the same time as
users aer able to edit ranges.

Cheers
--
Deirdre


"EugeniaP" wrote:

This was a very helpful post. I was wondering if it's possible to create a
macro that would protect all the worksheets in the workbook but also allow
users to edit a certain range?

Thanks,
EugeniaP.

"Diddy" wrote:

Thank you Bob :-)
--
Deirdre


"Bob Phillips" wrote:

Just loop them all

For Each sh In Activeworkbook.Worksheets

sh.Protect
Next sh

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Diddy" wrote in message
...
Hi Bob,

Following on from that, how would you code it to protect all sheets in the
workbook?

Cheers
--
Deirdre


"Bob Phillips" wrote:

When a macro runs the sheet is already effectively locked. You can
protect
it afterwards with

worksheets("Sheet1").Protect

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"des-sa" wrote in message
...
hi again
is there a way to have macro lock a specific sheet for editing when the
macro is run, then maybe have it password protected for editing
afterwards
thanks