Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / December 2004

Tip: Looking for answers? Try searching our database.

Silly little annoyance

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
- 21 Dec 2004 19:22 GMT
Greetings all,

Silly little thing that bugs me. I'd like to turn off the prompt I receive
whenever I exit Excel (2003). If I have previously used the Windows
Clipboard to copy ANYTHING, be it the contents of one cell or a whole
spreadsheet, Excel just has to ask me whether or not I want to keep a
"large" amount of data in the Clipboard for use with other applications. YES
YES YES, just stop asking me every time I exit Excel!

Thanks for your help. Happy Holidays!

Larry
Dave Peterson - 21 Dec 2004 20:54 GMT
If you hit the Escape key before you close excel, do you get the warning.

> Greetings all,
>
[quoted text clipped - 8 lines]
>
> Larry

Signature

Dave Peterson

- 21 Dec 2004 23:38 GMT
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

- 22 Dec 2004 20:02 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.