CommandButton Focus Question

[wildduffy]

I created a commandbutton that calls a routine to print x number of
copies of a selected sheet based on the value of a specific cell.

My problem is that when I change the value in the cell, I have to
click elsewhere or press enter before I click on my commandbutton in
order for it to work. I have tried changing the value of
TakeFocusOnClick but neither seems to work,

Any ideas? I have Excell 2000.


Thanks in advance.

 

[NickHK]

VBA cannot run when you are in Edit Mode - when the cursor is blinking in a
cell.
No option.

By the way, TakeFocusOnClick relates to whether the commandbutton takes the
focus away from the WS when it is clicked. In this situation, it will not
help.

NickHK