Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unable to paste a formula into other cells
Hello,
I have a spreadsheet in Excel 2003 and have the following problem. Details. It is a protected worksheet, but the malfunction occurs whether it's protected or unprotected. Whenever I try to copy (works fine and is visible in the toolbar) an item (formula, words, etc) I am able to use the edit copy command or the control c command. I'll go to my cell where I want to paste it and the paste function isn't operational and neither is the control v. Whenever I open another "new" worksheet the copy/paste functions work fine. Since this a is pretty complex worksheet that I had some assistance on building I don't know where to start. Does anyone have any idea what the problem might be, or would someone be will to take a look at it for me to see if it can be fixed. Thanks Bob Reynolds |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unable to paste a formula into other cells
Your problem is that you have a selection event to color the active cell
which does not allow the copy. Put a 1 in cell A4 and insert this in the first line of your selection event if range("a4")=1 then exit sub -- Don Guillett SalesAid Software "rjr" wrote in message .. . Hello, I have a spreadsheet in Excel 2003 and have the following problem. Details. It is a protected worksheet, but the malfunction occurs whether it's protected or unprotected. Whenever I try to copy (works fine and is visible in the toolbar) an item (formula, words, etc) I am able to use the edit copy command or the control c command. I'll go to my cell where I want to paste it and the paste function isn't operational and neither is the control v. Whenever I open another "new" worksheet the copy/paste functions work fine. Since this a is pretty complex worksheet that I had some assistance on building I don't know where to start. Does anyone have any idea what the problem might be, or would someone be will to take a look at it for me to see if it can be fixed. Thanks Bob Reynolds |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning a cell's formula in a different cell | Excel Worksheet Functions | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
quick way to copy-paste a formula linked to cells in another file | Excel Worksheet Functions | |||
copy & paste spreadsheet cells from excel to outlook to excel | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions |