Jeff,

Is this a UserForm? The macro has no control while a UserForm is open, one
exception when the form is shown modeless. Then the macro that showed it
will keep running, can end, and your original macro that opened the workbook
will regain control.

From your other post, I gather this form shows automatically when the sheet
is selected. Perhaps you can change the macro that shows the form so that
it shows it when a button is clicked instead.

Provide more info.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"jeffP" wrote in message
...
Here's my minor dilemma, hope you can help.
I have two workbooks. From workbook(1) I open WB(2)where
I'm going to copy a sheet and paste it to WB(1). My
problem is that I have a form that opens when the sheet is
activated.
I recorded a macro to do this but it stops when the form
opens (and continues when I close it). It's not a big deal
but I'd like a more seamless operation.

Any help is appreciated.
JeffP