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
|