Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with options from within Tools Options clears the Clipboar
Good afternoon,
Can anyone tell me why when, if I copy something to the Clipboard, then try to change a setting to something like scroll bars, worksheet tabs, formula bar etc, the clipboard empties? This works in "normal" Excel, as well as VBA - do a copy, then select "Tools" and "Options" from the menu, and the carousel line around the selection disappears! It's causing me MAJOR problems - I'm using 2003 on XP Thanks Pete |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with options from within Tools Options clears the Clipboar
In code and manually, it is best to do the copy and paste as one set of
actions with no intermediate actions. As to why, I would imagine that Excel errs on the side of caution in assuming that almost any action outside of pasting could change the environment of what was copied. -- Regards, Tom Ogilvy "Peter Rooney" wrote in message ... Good afternoon, Can anyone tell me why when, if I copy something to the Clipboard, then try to change a setting to something like scroll bars, worksheet tabs, formula bar etc, the clipboard empties? This works in "normal" Excel, as well as VBA - do a copy, then select "Tools" and "Options" from the menu, and the carousel line around the selection disappears! It's causing me MAJOR problems - I'm using 2003 on XP Thanks Pete |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with options from within Tools Options clears the Clip
Tom,
I agree, except that I'm not doing a straight pasts, trather I'm having to do two paste specials, one for values and one for formats, so it's not that easy. Thanks for your thoughts Pete "Tom Ogilvy" wrote: In code and manually, it is best to do the copy and paste as one set of actions with no intermediate actions. As to why, I would imagine that Excel errs on the side of caution in assuming that almost any action outside of pasting could change the environment of what was copied. -- Regards, Tom Ogilvy "Peter Rooney" wrote in message ... Good afternoon, Can anyone tell me why when, if I copy something to the Clipboard, then try to change a setting to something like scroll bars, worksheet tabs, formula bar etc, the clipboard empties? This works in "normal" Excel, as well as VBA - do a copy, then select "Tools" and "Options" from the menu, and the carousel line around the selection disappears! It's causing me MAJOR problems - I'm using 2003 on XP Thanks Pete |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with options from within Tools Options clears the Clip
If you do them with no intermediate steps, then I am not sure how that
differentiates your situation from what I advised. I have never had any trouble doing that (following my advice). -- Regards, Tom Ogilvy "Peter Rooney" wrote in message ... Tom, I agree, except that I'm not doing a straight pasts, trather I'm having to do two paste specials, one for values and one for formats, so it's not that easy. Thanks for your thoughts Pete "Tom Ogilvy" wrote: In code and manually, it is best to do the copy and paste as one set of actions with no intermediate actions. As to why, I would imagine that Excel errs on the side of caution in assuming that almost any action outside of pasting could change the environment of what was copied. -- Regards, Tom Ogilvy "Peter Rooney" wrote in message ... Good afternoon, Can anyone tell me why when, if I copy something to the Clipboard, then try to change a setting to something like scroll bars, worksheet tabs, formula bar etc, the clipboard empties? This works in "normal" Excel, as well as VBA - do a copy, then select "Tools" and "Options" from the menu, and the carousel line around the selection disappears! It's causing me MAJOR problems - I'm using 2003 on XP Thanks Pete |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with options from within Tools Options clears the Clip
Tom,
Following your advice, I'm going to see if I can do a copy and paste special in one go, as I've never done it before. However, your other post about enableevents=false solved this problem anyway, as since I'm now no longer running the window view changes. I don't lose the contents of the clipboard!" :-) Once again, thanks for your help Pete "Tom Ogilvy" wrote: If you do them with no intermediate steps, then I am not sure how that differentiates your situation from what I advised. I have never had any trouble doing that (following my advice). -- Regards, Tom Ogilvy "Peter Rooney" wrote in message ... Tom, I agree, except that I'm not doing a straight pasts, trather I'm having to do two paste specials, one for values and one for formats, so it's not that easy. Thanks for your thoughts Pete "Tom Ogilvy" wrote: In code and manually, it is best to do the copy and paste as one set of actions with no intermediate actions. As to why, I would imagine that Excel errs on the side of caution in assuming that almost any action outside of pasting could change the environment of what was copied. -- Regards, Tom Ogilvy "Peter Rooney" wrote in message ... Good afternoon, Can anyone tell me why when, if I copy something to the Clipboard, then try to change a setting to something like scroll bars, worksheet tabs, formula bar etc, the clipboard empties? This works in "normal" Excel, as well as VBA - do a copy, then select "Tools" and "Options" from the menu, and the carousel line around the selection disappears! It's causing me MAJOR problems - I'm using 2003 on XP Thanks Pete |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with options from within Tools Options clears the Clip
One go doesn't mean one command. Paste Special requires two commands
(separate copy and paste), but they should be contiguous in your code. -- Regards, Tom Ogilvy "Peter Rooney" wrote in message ... Tom, Following your advice, I'm going to see if I can do a copy and paste special in one go, as I've never done it before. However, your other post about enableevents=false solved this problem anyway, as since I'm now no longer running the window view changes. I don't lose the contents of the clipboard!" :-) Once again, thanks for your help Pete "Tom Ogilvy" wrote: If you do them with no intermediate steps, then I am not sure how that differentiates your situation from what I advised. I have never had any trouble doing that (following my advice). -- Regards, Tom Ogilvy "Peter Rooney" wrote in message ... Tom, I agree, except that I'm not doing a straight pasts, trather I'm having to do two paste specials, one for values and one for formats, so it's not that easy. Thanks for your thoughts Pete "Tom Ogilvy" wrote: In code and manually, it is best to do the copy and paste as one set of actions with no intermediate actions. As to why, I would imagine that Excel errs on the side of caution in assuming that almost any action outside of pasting could change the environment of what was copied. -- Regards, Tom Ogilvy "Peter Rooney" wrote in message ... Good afternoon, Can anyone tell me why when, if I copy something to the Clipboard, then try to change a setting to something like scroll bars, worksheet tabs, formula bar etc, the clipboard empties? This works in "normal" Excel, as well as VBA - do a copy, then select "Tools" and "Options" from the menu, and the carousel line around the selection disappears! It's causing me MAJOR problems - I'm using 2003 on XP Thanks Pete |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with options from within Tools Options clears the Clip
Tom,
I thought that was the case, but didn't want to say so until I'd proved otherwise. Anyway, the problem's now been solved, thanks to your EnableEvents tip. Off to Glastonbury for a well earned rest for a couple of days now, leaving behind a fully working code-compromise-free solution (bet it will have crashed when I get back, though! :-) ) Have a good weekend Pete "Tom Ogilvy" wrote: One go doesn't mean one command. Paste Special requires two commands (separate copy and paste), but they should be contiguous in your code. -- Regards, Tom Ogilvy "Peter Rooney" wrote in message ... Tom, Following your advice, I'm going to see if I can do a copy and paste special in one go, as I've never done it before. However, your other post about enableevents=false solved this problem anyway, as since I'm now no longer running the window view changes. I don't lose the contents of the clipboard!" :-) Once again, thanks for your help Pete "Tom Ogilvy" wrote: If you do them with no intermediate steps, then I am not sure how that differentiates your situation from what I advised. I have never had any trouble doing that (following my advice). -- Regards, Tom Ogilvy "Peter Rooney" wrote in message ... Tom, I agree, except that I'm not doing a straight pasts, trather I'm having to do two paste specials, one for values and one for formats, so it's not that easy. Thanks for your thoughts Pete "Tom Ogilvy" wrote: In code and manually, it is best to do the copy and paste as one set of actions with no intermediate actions. As to why, I would imagine that Excel errs on the side of caution in assuming that almost any action outside of pasting could change the environment of what was copied. -- Regards, Tom Ogilvy "Peter Rooney" wrote in message ... Good afternoon, Can anyone tell me why when, if I copy something to the Clipboard, then try to change a setting to something like scroll bars, worksheet tabs, formula bar etc, the clipboard empties? This works in "normal" Excel, as well as VBA - do a copy, then select "Tools" and "Options" from the menu, and the carousel line around the selection disappears! It's causing me MAJOR problems - I'm using 2003 on XP Thanks Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
tools options view window options | Excel Discussion (Misc queries) | |||
Tools / Options not working. | Excel Discussion (Misc queries) | |||
Tools - Options not working | Excel Discussion (Misc queries) | |||
How to diasble the 'Tools - Options - View - Comments' options? | Excel Programming | |||
Tools-Options | Excel Programming |