VBA - Clear the clipboard before closing file

[dipsy]

Hi! I have a template where I have allowed users to
insert rows.
I use the following code:

Range("a52").Select
Selection.EntireRow.Insert
Rows("53:53").Copy
Rows("52:52").Select
Selection.PasteSpecial Paste:=xlFormulas,
Operation:=xlNone, SkipBlanks:= False, Transpose:=False
Range("a2").Select



However, when the user closes the file - there is a huge
amt of data on the clip board and I do not want the user
to get the message - is there a way for me to clear the
information on the clip board?

Also what does "Application.CutCopyMode = False" do?

Thanks!

 

[icestationzbra]

searching with the keyword "clipboard" spat out at least a couple of
useful posts. it would have saved you sometime, too.

http://www.excelforum.com/showthread.php?threadid=250371&highlight=clipboard

http://www.excelforum.com/showthread.php?threadid=250272&highlight=clipboard

http://www.excelforum.com/showthread.php?threadid=249587&highlight=clipboard