I have been working with some code to take data from a
master workbook and create multiple other workbooks and
sheets. Everything works fine except that after copying
and pasting the data onto a secondary sheet, saving it and
closing it... I get a dialog box about emptying the
clipboard that requires input. Is there a way in the code
to empty the clipboard prior to closing my secondary
sheet? Or, perhaps a way to stop the dialog box from
appearing? I do not want the program interupted each time
a secondary sheet is closed... as I am creating a couple
hundred of them at a time.
Thanks!! patrick

Application.Cutcopymode = False

will enter the clipboard if it contains a large range (which sounds like the
case).

--
Regards,
Tom Ogilvy


"Patrick" wrote in message
...
I have been working with some code to take data from a
master workbook and create multiple other workbooks and
sheets. Everything works fine except that after copying
and pasting the data onto a secondary sheet, saving it and
closing it... I get a dialog box about emptying the
clipboard that requires input. Is there a way in the code
to empty the clipboard prior to closing my secondary
sheet? Or, perhaps a way to stop the dialog box from
appearing? I do not want the program interupted each time
a secondary sheet is closed... as I am creating a couple
hundred of them at a time.
Thanks!! patrick