Excel 2003 VBA Question
 

I have a macro in an Excel Workbook that opens another workbook an
copies some information and pastes it in the first workbook and goes o
to do some formatting.

How can I avoid a Microsoft message that there is information on th
clipboard - do I want to save clipboard information - Yes or No. M
macro runs and then this message appears but I want to bypass it.

I don't do much programming at all. Appreciate any help. Thank you

--
ma
-----------------------------------------------------------------------
mab's Profile: http://www.excelforum.com/member.php...nfo&userid=366
View this thread: http://www.excelforum.com/showthread.php?threadid=37611

Excel 2003 VBA Question
 

Application.DisplayAlerts = False
will prevent those messages. Use with care.

HTH. Best wishes Harald


"mab" skrev i melding
...

I have a macro in an Excel Workbook that opens another workbook and
copies some information and pastes it in the first workbook and goes on
to do some formatting.

How can I avoid a Microsoft message that there is information on the
clipboard - do I want to save clipboard information - Yes or No. My
macro runs and then this message appears but I want to bypass it.

I don't do much programming at all. Appreciate any help. Thank you.


--
mab
------------------------------------------------------------------------
mab's Profile:
http://www.excelforum.com/member.php...fo&userid=3667
View this thread: http://www.excelforum.com/showthread...hreadid=376119

Excel 2003 VBA Question
 

Thank you so very much

--
ma
-----------------------------------------------------------------------
mab's Profile: http://www.excelforum.com/member.php...nfo&userid=366
View this thread: http://www.excelforum.com/showthread.php?threadid=37611