If you hit the Escape key before you close excel, do you get the warning.
Dave, yes that stops the annoying warning dialog, but I DO want the
contents to remain in the Clipboard, I just want Excel to stop worrying and
completely ignore what is or isn't in the Clipboard when I exit.
Thanks,
> If you hit the Escape key before you close excel, do you get the warning.
>
[quoted text clipped - 10 lines]
> >
> > Larry
Dave Peterson - 22 Dec 2004 01:46 GMT
I don't think you can turn this behavior off.
You might be able to use a macro to dismiss the warning, but just running a
macro causes the clipboard to be cleared.
And then instead of being irritated by having to click to dismiss the dialog,
you'd be irritated by having to run the code.
And this ain't much of a tip, but you can hit the Y key if your fingers are on
the keyboard.
> Dave, yes that stops the annoying warning dialog, but I DO want the
> contents to remain in the Clipboard, I just want Excel to stop worrying and
[quoted text clipped - 22 lines]
> >
> > Dave Peterson

Signature
Dave Peterson
Thanks Dave.
I just don't understand why Excel thinks one cell or one row is "a large
amount of information." Must be some sort of holdover from the days of Excel
4.0, Windows 3.1 and 386 processors. :-)
Larry
> I don't think you can turn this behavior off.
>
[quoted text clipped - 33 lines]
> > >
> > > Dave Peterson
Gord Dibben - 22 Dec 2004 20:44 GMT
Larry
Or maybe a holdover from Version 2(1987) which was designed to run on Windows
2.0(1987) and 80286 processors.
Gord Dibben Excel MVP
>Thanks Dave.
>
[quoted text clipped - 49 lines]
>> > >
>> > > Dave Peterson
Dave Peterson - 22 Dec 2004 21:32 GMT
Just to add to Gord's reply...
It may depend on how you categorize "a large amount". Remember that excel will
keep track of the formula, values, and formatting for that copied range. And
that could be lots of information.
> Thanks Dave.
>
[quoted text clipped - 53 lines]
> >
> > Dave Peterson

Signature
Dave Peterson