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.

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



wrote in message
ps.com...
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.