How do I lock cells so their values don't get updated

[AndrewOZ]

I have a worksheet (A) which gets updated by cell values in another worksheet
(B). Worksheet A is only valid up to a particular date. After that date, I
want to be able to lock every value in the worksheet A so that I can still
update worksheet B (manually) and NOT have worksheet a updated. Is there a
way to do this or do I need to go to a VBA solution?

thanks

[Dave Peterson]

Copy|paste special|values

When you want.

AndrewOZ wrote:
>
> I have a worksheet (A) which gets updated by cell values in another worksheet
> (B). Worksheet A is only valid up to a particular date. After that date, I
> want to be able to lock every value in the worksheet A so that I can still
> update worksheet B (manually) and NOT have worksheet a updated. Is there a
> way to do this or do I need to go to a VBA solution?
>
> thanks

--

Dave Peterson

[Andrew]

Thanks Dave - works a treat!


"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> Copy|paste special|values
>
> When you want.
>
> AndrewOZ wrote:
>>
>> I have a worksheet (A) which gets updated by cell values in another
>> worksheet
>> (B). Worksheet A is only valid up to a particular date. After that date,
>> I
>> want to be able to lock every value in the worksheet A so that I can
>> still
>> update worksheet B (manually) and NOT have worksheet a updated. Is there
>> a
>> way to do this or do I need to go to a VBA solution?
>>
>> thanks
>
> --
>
> Dave Peterson