Thread: freeze cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LL0rd LL0rd is offline
external usenet poster
 
Posts: 1
Default freeze cells


Hi,

I've got a little problem with Excel. I have to protect some cells from
changing its value. One little example: A1=2; A2=3; C1=A1*A2;

Now we have C1=6. But if you change the value of A1 or A2, the value of
C1 also changes. How can I freeze the Value? I have to do it by a macro,
because there are lots of different cells to freeze.


--
LL0rd
------------------------------------------------------------------------
LL0rd's Profile: http://www.excelforum.com/member.php...o&userid=23712
View this thread: http://www.excelforum.com/showthread...hreadid=373879