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.