I have a file from which I have done a copy/paste for a fair amount
of data. I have a macro to do this, and wish to close the window
totally. However when I use:

ActiveWorkbook.Close

I get a message asking whether I want to save the data on the
clipboard. I have looked in "help" for options to supress this
message, but cannot find them.Can someone give me the answer please.
Question is: How do I set the macro to avoid this message when
closing!!

Thanks in advance

John Baker

hi
usually the best method is to turn off alerts at the begining of the macro
then turn them back on at the end.

Application.DisplayAlerts = False
your code here
ActiveWorkbook.Close
Application.DisplayAlerts = True

regards
FSt1

"JHB" wrote:

I have a file from which I have done a copy/paste for a fair amount
of data. I have a macro to do this, and wish to close the window
totally. However when I use:

ActiveWorkbook.Close

I get a message asking whether I want to save the data on the
clipboard. I have looked in "help" for options to supress this
message, but cannot find them.Can someone give me the answer please.
Question is: How do I set the macro to avoid this message when
closing!!

Thanks in advance

John Baker

On Aug 2, 9:12*pm, FSt1 wrote:
hi
usually the best method is to turn off alerts at the begining of the macro
then turn them back on at the end.

Application.DisplayAlerts = False
your code here
ActiveWorkbook.Close
Application.DisplayAlerts = True

regards
FSt1

"JHB" wrote:
I *have a file from which I have done a copy/paste for a fair amount
of data. I have a macro to do this, and wish to close the window
totally. However when I use:

ActiveWorkbook.Close

I get a message asking whether I want to save the data on the
clipboard. I have looked in "help" for options to supress this
message, but cannot find them.Can someone give me the answer please.
Question is: How do I set the macro to avoid this message when
closing!!

Thanks in advance

John Baker

Thanks..very helpful!