software

Hello,

I have a problem the my paste function. Whenever I copy (copy seems to work
ok with the marquee and selection process) and then try to paste the data
into another cell, it won't let me. the Paste function is greyed out. The
worksheet is unprotected and I'm in Excel 2003.
Any ideas.
Bob Reynolds
Do you have any event macros running--maybe worksheet_selectionchange??

Lots of macros will kill the clipboard.

If you close excel and reopen in safe mode (one way to stop macros from
running), does it work ok?

Close excel
windows start button|Run
excel /safe
file|open your workbook and test it out.

Bob Reynolds wrote:
gt;
gt; Hello,
gt;
gt; I have a problem the my paste function. Whenever I copy (copy seems to work
gt; ok with the marquee and selection process) and then try to paste the data
gt; into another cell, it won't let me. the Paste function is greyed out. The
gt; worksheet is unprotected and I'm in Excel 2003.
gt; Any ideas.
gt; Bob Reynolds

--

Dave Peterson

Thanks for the input, that did it for that workbook. Now I must find the
macro creating the problem so I can fix it. Is there any generic statements
that one can think of specifically or I guess I have to go with each one and
check it out?

Thanks again.
quot;Dave Petersonquot; gt; wrote in message
...
gt; Do you have any event macros running--maybe worksheet_selectionchange??
gt;
gt; Lots of macros will kill the clipboard.
gt;
gt; If you close excel and reopen in safe mode (one way to stop macros from
gt; running), does it work ok?
gt;
gt; Close excel
gt; windows start button|Run
gt; excel /safe
gt; file|open your workbook and test it out.
gt;
gt; Bob Reynolds wrote:
gt;gt;
gt;gt; Hello,
gt;gt;
gt;gt; I have a problem the my paste function. Whenever I copy (copy seems to
gt;gt; work
gt;gt; ok with the marquee and selection process) and then try to paste the data
gt;gt; into another cell, it won't let me. the Paste function is greyed out. The
gt;gt; worksheet is unprotected and I'm in Excel 2003.
gt;gt; Any ideas.
gt;gt; Bob Reynolds
gt;
gt; --
gt;
gt; Dave Peterson
I don't know what code kills the clipboard. But when you're testing you can
pepper your code with lines like:

debug.print quot;step 99: quot; amp; application.cutcopymode
'do step 99
debug.print quot;step 100: quot; amp; application.cutcopymode

When you look at the the immediate window, you'll be able to see where it
changed status.

Kind of a divide and conquer technique.
Bob Reynolds wrote:
gt;
gt; Thanks for the input, that did it for that workbook. Now I must find the
gt; macro creating the problem so I can fix it. Is there any generic statements
gt; that one can think of specifically or I guess I have to go with each one and
gt; check it out?
gt;
gt; Thanks again.
gt; quot;Dave Petersonquot; gt; wrote in message
gt; ...
gt; gt; Do you have any event macros running--maybe worksheet_selectionchange??
gt; gt;
gt; gt; Lots of macros will kill the clipboard.
gt; gt;
gt; gt; If you close excel and reopen in safe mode (one way to stop macros from
gt; gt; running), does it work ok?
gt; gt;
gt; gt; Close excel
gt; gt; windows start button|Run
gt; gt; excel /safe
gt; gt; file|open your workbook and test it out.
gt; gt;
gt; gt; Bob Reynolds wrote:
gt; gt;gt;
gt; gt;gt; Hello,
gt; gt;gt;
gt; gt;gt; I have a problem the my paste function. Whenever I copy (copy seems to
gt; gt;gt; work
gt; gt;gt; ok with the marquee and selection process) and then try to paste the data
gt; gt;gt; into another cell, it won't let me. the Paste function is greyed out. The
gt; gt;gt; worksheet is unprotected and I'm in Excel 2003.
gt; gt;gt; Any ideas.
gt; gt;gt; Bob Reynolds
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson

--

Dave Peterson