Hi Howard,

I have sent you a revised workbook which works, I think, as you wish.

I have moved non-event code from the sheet module to your standard module
and reassigned the buttons to point to the changed macro locations.

I have commented out a selection line in the Worksheet_Change event because
(a) I could see no obvious need for the selection and (b) because it was
this line that was causing your observed problem. In case you do need the
selection elsewhere, I have amended the copy macro to turn events off at the
start and turn events back on at the end of the code. Whatever you do with
the selection line in the event code, you can leave the Copy macro in its
amended state.


---
Regards,
Norman



"L. Howard Kittle" wrote in message
...
I deleted one too many letters on the first try. Hopefully, one on the
way.