Excel Visual Basic Help

jghal

Fantastic. thank you so much.

Last one - promise ;-)

The CopyInfo code shown is just a portion of the entire CopyInfo code. I have made all the necessary changes to the entire code and it all works

However, when my code shuts down the variable workbook it asks if I want to keep the information previously copied on the clipboard. I don't need this kept - can I

a) remove it from the clipboard automatically and prevent this message

OR

b) just prevent this message appearing and keep the info on the clipboard (it really won't matter that much

Thanks in advance

Mobeer

It seems from a brief search that clearing the clipboard is rather difficult using VBA.

You could try this approach (add in code and use API calls)

Or you could try an alternative approach (add in a forms reference and use it)

Chippy_Minton

Not sure if this will work, but try:

Application.CutCopyMode = False

jghal

Thanks All

Mobeer's first suggestion did the trick - many thanks

Now have my spreadsheet working exactly as I want it.

This is a great forum - ask a question, get it sorted - just what it says on the tin

Absolutely fantastic

:beer; :beer: