Thanks Gord, that works fine.

Don, thanks for the advice but sometimes i dont want to close all workbooks
though just the current one, im typicaly using 2 or 3 at a time.

"Gord Dibben" wrote:

Application.CutCopyMode = False

Stick this in after any paste step to clear the clipboard.


Gord Dibben MS Excel MVP

On Tue, 14 Nov 2006 08:37:01 -0800, Bry wrote:

Hi

i have a number of macro's that open and close different wokbooks to analyse
data. at the moment they run fine but i have to manualy click 'no' on saving
changes and to indicate that the large amount of information on the clipboard
is no longer required. can someone please tell me the code to enter to do
this?

many thanks
Bry