Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste grays out after function performed
hello, i made some code to do some background calculations in my excel sheet. but very strange: when i open the excel the first time i can paste cells from another workbook. after the functions are performed, i see the paste button is grayed out and when i try to copy from another workbook it doesnt work. pasting from another worksheet in the same workbook everything is ok.... i don't get it! anyone knows what to do??? thanks in advance. -- stt_d31 ------------------------------------------------------------------------ stt_d31's Profile: http://www.excelforum.com/member.php...o&userid=24040 View this thread: http://www.excelforum.com/showthread...hreadid=379150 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste grays out after function performed
When a macro runs it clears out the clipboard so whatever you copied can not
be pasted. As a guess you have an event that is firing (even if it is doing nothing) and whatever you have copied is getting wiped out. Check out your activate/deactivate and change events to see if you have any macros that are firing... -- HTH... Jim Thomlinson "stt_d31" wrote: hello, i made some code to do some background calculations in my excel sheet. but very strange: when i open the excel the first time i can paste cells from another workbook. after the functions are performed, i see the paste button is grayed out and when i try to copy from another workbook it doesnt work. pasting from another worksheet in the same workbook everything is ok.... i don't get it! anyone knows what to do??? thanks in advance. -- stt_d31 ------------------------------------------------------------------------ stt_d31's Profile: http://www.excelforum.com/member.php...o&userid=24040 View this thread: http://www.excelforum.com/showthread...hreadid=379150 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste grays out after function performed
the problem becomes more weird every minute: when i open my excel workbook (with some vba functions) i can copy/paste from whatever worksheet in this workbook i want as a much as i want. when i open a new excel sheet by choosing FileNew frow within my excel workbook, i can do paste from that new workbook only once. Thereafter the paste and paste special tool becomes grayed out in my workbook. when i open a new excel sheet by choosing "Windows Start""Excel" (opening excel by clicking the windows shortcut) so also a new worksheet is opened, i can do copy paste back again as much as i want !!! anyone understands this weird behaviour? -- stt_d31 ------------------------------------------------------------------------ stt_d31's Profile: http://www.excelforum.com/member.php...o&userid=24040 View this thread: http://www.excelforum.com/showthread...hreadid=379150 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula appears, but its function is not performed????? | Excel Worksheet Functions | |||
Excel Chart grays out after you deselect it. | Charts and Charting in Excel | |||
Minimizing excel window grays it out on taskbar | Excel Discussion (Misc queries) | |||
Unprotection once performed... | Excel Discussion (Misc queries) | |||
Spinbutton grays out toolbars | Excel Programming |