Do you wish to clear clipboard memory?

I have a macro that is accessing multiple spreadsheets and extracting data
and pasteing to a summary spreadsheet.

This is working fine, except when it closes each sheet, I get the message
"You have data in your clipboard do you wish to save or clear memory" - how
can I skip this or switch it off?

Any help would be gratefully received, its driving me nuts - whats the point
of having a macro if I have to sit there and press return after each
update!!!

Thank you,

Wendy
Telford

after each paste and before closing

application.CutCopyMode = False

or around the closing command

Application.DisplayAlerts = False
' closing code
Application.DisplayAlerts = True

--
Regards,
Tom Ogilvy

"WendyUK" <WendyUK@discussions.microsoft.com> wrote in message
news:145ABE68-C0DF-4B36-A649-62141AC2250A@microsoft.com...
> I have a macro that is accessing multiple spreadsheets and extracting data
> and pasteing to a summary spreadsheet.
>
> This is working fine, except when it closes each sheet, I get the message
> "You have data in your clipboard do you wish to save or clear memory" -
how
> can I skip this or switch it off?
>
> Any help would be gratefully received, its driving me nuts - whats the
point
> of having a macro if I have to sit there and press return after each
> update!!!
>
> Thank you,
>
> Wendy
> Telford
>
>

You are a wonderful person, and have saved my sanity - thank you so much.

Wendy x

"Tom Ogilvy" wrote:

> after each paste and before closing
>
> application.CutCopyMode = False
>
> or around the closing command
>
> Application.DisplayAlerts = False
> ' closing code
> Application.DisplayAlerts = True
>
> --
> Regards,
> Tom Ogilvy
>
> "WendyUK" <WendyUK@discussions.microsoft.com> wrote in message
> news:145ABE68-C0DF-4B36-A649-62141AC2250A@microsoft.com...
> > I have a macro that is accessing multiple spreadsheets and extracting data
> > and pasteing to a summary spreadsheet.
> >
> > This is working fine, except when it closes each sheet, I get the message
> > "You have data in your clipboard do you wish to save or clear memory" -
> how
> > can I skip this or switch it off?
> >
> > Any help would be gratefully received, its driving me nuts - whats the
> point
> > of having a macro if I have to sit there and press return after each
> > update!!!
> >
> > Thank you,
> >
> > Wendy
> > Telford
> >
> >
>
>
>