Tom, thank's!

you gave me idea how to solve this problem, with takefocusonclick i did not
solve my problem, but with activating one cell on worksheet!

Regards,
Milos

"Tom Ogilvy" wrote in message
...
If your code is being executed from a commandbutton from the control
toolbox
toolbar, then set the TakeFocusOnClick property of the commandbutton to
false.

--
Regards,
Tom Ogilvy


"M." wrote in message
...
I'm using Excel 97.
My code stoped on this line of code:

Worksheets("PROGRAM").Range("26:26").Copy
Destination:=Worksheets("SEZNAM
UO").Range("1430:1430")

Active worksheet is "PROGRAM"!

I'd like to copy entire row witch location has writen in variable from
one
worksheet to another with diferent row number.

Thank's on advice!

Milos