Hi there,

I have made a macro with a keyhandler that enters the value "1" in a Calc-cell
everytime I press "F1" or "ALT-z". The high of cell gets smaller every time "F1"
is pressed. The row nuber keeps unchanged (a it should be). F.i. after pressing
"F1" several times the cells on line/row 7 that should show behind row nuber 7
are behind row number 6!. When I refresh the screen. Everything oke (untill i
presses "F1" again). Same thing with the ALT-z key. I found out it has something
to do wit h the conditional formatting on the cells. The Format profiel has been
taken over by Calc from the original Excel file.

I made two control cells in the calcsheet if the value of controlcell2 = "p"
than the conditional format 2 should be applied on some other cells else if
controlcell2 = "c" than conditional format 1 should be applied. 

If I change the setting of controlcell 2 from "p" in "c" and back again. The
problem is solved. If I remove the Controlcell1 (wich has noting to do with the
conditional format). Than the problem is solved also. If I enter the value "1"
by hand (=whitout the keyhandler), there is also no problem....

Strange, but true. I whould like to ad the Calc-file so you could just press
"F1" or "ALT-z" and see... However, I don't see the option to add the file...

Robby