Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste function is greyed out in the toolbar and I can't use ctl V - worksheet won't allow pasting
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste function is greyed out in the toolbar and I can't use ctl V -worksheet won't allow pasting
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: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste function is greyed out in the toolbar and I can't use ctl V - worksheet won't allow pasting
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. "Dave Peterson" wrote in message ... 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: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste function is greyed out in the toolbar and I can't use ctl V -worksheet won't allow pasting
I don't know what code kills the clipboard. But when you're testing you can
pepper your code with lines like: debug.print "step 99: " & application.cutcopymode 'do step 99 debug.print "step 100: " & 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: 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. "Dave Peterson" wrote in message ... 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: 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 -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
toolbar macros that dont change when worksheet is renamed | New Users to Excel | |||
Toolbar problem | Excel Discussion (Misc queries) | |||
how do I add sum function to the toolbar permanently | Excel Discussion (Misc queries) | |||
How do I add the count function to the toolbar? | Excel Worksheet Functions | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |