I'm trying to get rid of a clip board message that comes up when my macro is
running. The pop says "large amounts of data...."
It's stopping my macro from completly automating my task.
any help would be appreciated. my email is [email protected]
I'm trying to get rid of a clip board message that comes up when my macro is
running. The pop says "large amounts of data...."
It's stopping my macro from completly automating my task.
any help would be appreciated. my email is [email protected]
Put in
Application.cutcopymode=false
Before your next copy routine
that popup shows when you close a workbook
(and have previously copied stuff)
To clear the clipboard
use application.CutCopyMode=False
You could do it prior to closing the workbook,
but maybe best to use it as soon as you're done
with copy/paste
In case you Do need the data on the clipboard,
and just dont want the message use:
Application.DisplayAlerts = False
do it just before you close the book
and set it back to True when you're done.
--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam
Timmulla wrote :
> I'm trying to get rid of a clip board message that comes up when my
> macro is running. The pop says "large amounts of data...."
>
> It's stopping my macro from completly automating my task.
>
> any help would be appreciated. my email is [email protected]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks