closing form w/ Maco
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
|