mass changes to cell protection

[Adam Kroger]

Is there a way to alter the cell protection based on a condition instead of
going in and manually changing them?

more exact: I want to protect all my cells that have a formula, and
un-protect the ones that do not.

[Paul B]

Adam, on way, select all the cells, Ctrl+a, unprotect them all, then edit,
go to, special, check formulas ok, then protect the cells that are selected

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Adam Kroger @hotmail.com>" <adam_kroger<nospam> wrote in message
news:ftidna3dfNayfxjenZ2dnUVZ_tKdnZ2d@comcast.com...
> Is there a way to alter the cell protection based on a condition instead
of
> going in and manually changing them?
>
> more exact: I want to protect all my cells that have a formula, and
> un-protect the ones that do not.
>
>

[Adam Kroger]

Paul:
I am using Excel97 (probably should have mentioned that) will they still
work for me? I did try, but <CTRL>A did not do anything, and I do not know
where the "Special" feature is.

Adam

"Paul B" <to_much_spam_to_list@nospam.com> wrote in message
news:ORweRIR8FHA.500@TK2MSFTNGP15.phx.gbl...
> Adam, on way, select all the cells, Ctrl+a, unprotect them all, then edit,
> go to, special, check formulas ok, then protect the cells that are
> selected
>
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "Adam Kroger @hotmail.com>" <adam_kroger<nospam> wrote in message
> news:ftidna3dfNayfxjenZ2dnUVZ_tKdnZ2d@comcast.com...
>> Is there a way to alter the cell protection based on a condition instead
> of
>> going in and manually changing them?
>>
>> more exact: I want to protect all my cells that have a formula, and
>> un-protect the ones that do not.
>>
>>
>
>
>

[Gord Dibben]

Adam

Hold CTRL key down and hit the "a" key on keyboard.

Alternative.....click on the gray rectangle at top left corner of the row and
column headers.

Either method will select all cells.

Format>Cells>Protection. Change to "unlocked" by clicking the checkmark out
of the option box. OK out.

Hit F5>Special>Formulas>OK

All cells with formulas are selected.

Format>Cells>Protection. Changed to "Locked". OK out.

Now Tools>Protection>Protect sheet>OK

Give a password or not.


Gord Dibben Excel MVP

On Thu, 24 Nov 2005 10:45:48 -0600, "Adam Kroger"
<adam_kroger<nospam>@hotmail.com> wrote:

>Paul:
>I am using Excel97 (probably should have mentioned that) will they still
>work for me? I did try, but <CTRL>A did not do anything, and I do not know
>where the "Special" feature is.
>
>Adam
>
>"Paul B" <to_much_spam_to_list@nospam.com> wrote in message
>news:ORweRIR8FHA.500@TK2MSFTNGP15.phx.gbl...
>> Adam, on way, select all the cells, Ctrl+a, unprotect them all, then edit,
>> go to, special, check formulas ok, then protect the cells that are
>> selected
>>
>> --
>> Paul B
>> Always backup your data before trying something new
>> Please post any response to the newsgroups so others can benefit from it
>> Feedback on answers is always appreciated!
>> Using Excel 2002 & 2003
>>
>> "Adam Kroger @hotmail.com>" <adam_kroger<nospam> wrote in message
>> news:ftidna3dfNayfxjenZ2dnUVZ_tKdnZ2d@comcast.com...
>>> Is there a way to alter the cell protection based on a condition instead
>> of
>>> going in and manually changing them?
>>>
>>> more exact: I want to protect all my cells that have a formula, and
>>> un-protect the ones that do not.
>>>
>>>
>>
>>
>>
>

[Adam Kroger]

Thanks for the step-by, it cleared up my haze.

Adam Kroger: Excel MoLC < More or Less Confused ;-) >

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:io4co19hdskeerq0r5sh4eaf6oe0m3oocm@4ax.com...
> Adam
>
> Hold CTRL key down and hit the "a" key on keyboard.
>
> Alternative.....click on the gray rectangle at top left corner of the row
> and
> column headers.
>
> Either method will select all cells.
>
> Format>Cells>Protection. Change to "unlocked" by clicking the checkmark
> out
> of the option box. OK out.
>
> Hit F5>Special>Formulas>OK
>
> All cells with formulas are selected.
>
> Format>Cells>Protection. Changed to "Locked". OK out.
>
> Now Tools>Protection>Protect sheet>OK
>
> Give a password or not.
>
>
> Gord Dibben Excel MVP
>
> On Thu, 24 Nov 2005 10:45:48 -0600, "Adam Kroger"
> <adam_kroger<nospam>@hotmail.com> wrote:
>
>>Paul:
>>I am using Excel97 (probably should have mentioned that) will they still
>>work for me? I did try, but <CTRL>A did not do anything, and I do not
>>know
>>where the "Special" feature is.
>>
>>Adam
>>
>>"Paul B" <to_much_spam_to_list@nospam.com> wrote in message
>>news:ORweRIR8FHA.500@TK2MSFTNGP15.phx.gbl...
>>> Adam, on way, select all the cells, Ctrl+a, unprotect them all, then
>>> edit,
>>> go to, special, check formulas ok, then protect the cells that are
>>> selected
>>>
>>> --
>>> Paul B
>>> Always backup your data before trying something new
>>> Please post any response to the newsgroups so others can benefit from it
>>> Feedback on answers is always appreciated!
>>> Using Excel 2002 & 2003
>>>
>>> "Adam Kroger @hotmail.com>" <adam_kroger<nospam> wrote in message
>>> news:ftidna3dfNayfxjenZ2dnUVZ_tKdnZ2d@comcast.com...
>>>> Is there a way to alter the cell protection based on a condition
>>>> instead
>>> of
>>>> going in and manually changing them?
>>>>
>>>> more exact: I want to protect all my cells that have a formula, and
>>>> un-protect the ones that do not.
>>>>
>>>>
>>>
>>>
>>>
>>
>

[Gord Dibben]

Thanks for the feedback Adam

Gord

On Thu, 24 Nov 2005 14:41:11 -0600, "Adam Kroger"
<adam_kroger<nospam>@hotmail.com> wrote:

>Thanks for the step-by, it cleared up my haze.
>
>Adam Kroger: Excel MoLC < More or Less Confused ;-) >
>
>"Gord Dibben" <gorddibbATshawDOTca> wrote in message
>news:io4co19hdskeerq0r5sh4eaf6oe0m3oocm@4ax.com...
>> Adam
>>
>> Hold CTRL key down and hit the "a" key on keyboard.
>>
>> Alternative.....click on the gray rectangle at top left corner of the row
>> and
>> column headers.
>>
>> Either method will select all cells.
>>
>> Format>Cells>Protection. Change to "unlocked" by clicking the checkmark
>> out
>> of the option box. OK out.
>>
>> Hit F5>Special>Formulas>OK
>>
>> All cells with formulas are selected.
>>
>> Format>Cells>Protection. Changed to "Locked". OK out.
>>
>> Now Tools>Protection>Protect sheet>OK
>>
>> Give a password or not.
>>
>>
>> Gord Dibben Excel MVP
>>
>> On Thu, 24 Nov 2005 10:45:48 -0600, "Adam Kroger"
>> <adam_kroger<nospam>@hotmail.com> wrote:
>>
>>>Paul:
>>>I am using Excel97 (probably should have mentioned that) will they still
>>>work for me? I did try, but <CTRL>A did not do anything, and I do not
>>>know
>>>where the "Special" feature is.
>>>
>>>Adam
>>>
>>>"Paul B" <to_much_spam_to_list@nospam.com> wrote in message
>>>news:ORweRIR8FHA.500@TK2MSFTNGP15.phx.gbl...
>>>> Adam, on way, select all the cells, Ctrl+a, unprotect them all, then
>>>> edit,
>>>> go to, special, check formulas ok, then protect the cells that are
>>>> selected
>>>>
>>>> --
>>>> Paul B
>>>> Always backup your data before trying something new
>>>> Please post any response to the newsgroups so others can benefit from it
>>>> Feedback on answers is always appreciated!
>>>> Using Excel 2002 & 2003
>>>>
>>>> "Adam Kroger @hotmail.com>" <adam_kroger<nospam> wrote in message
>>>> news:ftidna3dfNayfxjenZ2dnUVZ_tKdnZ2d@comcast.com...
>>>>> Is there a way to alter the cell protection based on a condition
>>>>> instead
>>>> of
>>>>> going in and manually changing them?
>>>>>
>>>>> more exact: I want to protect all my cells that have a formula, and
>>>>> un-protect the ones that do not.
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>
>>
>