NashvillePat
New Member
- Joined
- Mar 6, 2007
- Messages
- 11
This problem just started recently, so I wonder if is the result of an auto update done to Excel 2003.
When I copy one or more cells in one worksheet, then change worksheets the paste functions are not available. This is true no matter which method I try to use - right click, toolbar, or menu. It also happens when I copy from one workbook, open another, and change pages in the new workbook. If I copy from one workbook, open another workbook and don't change pages or selections it works just as it always has done. I can copy and paste within the same worksheet with no problems.
I can use the clipboard to perform the copy and paste, but the problem with that is that it pastes the value of a formula, not the formula.
I have noticed a similar problem in workbooks where my boss put some VBA code in to highlight the first and top cells of the column and row you are in. In that case, when you go back to the copied cell it is no longer in copy status. In these workbooks I can still copy within the same sheet with no problem.
Thank you in advance for any help that anyone can provide. I am an intermediate user and don't know much VBA, so please be patient if the answer is complicated and I have to ask more questions.
When I copy one or more cells in one worksheet, then change worksheets the paste functions are not available. This is true no matter which method I try to use - right click, toolbar, or menu. It also happens when I copy from one workbook, open another, and change pages in the new workbook. If I copy from one workbook, open another workbook and don't change pages or selections it works just as it always has done. I can copy and paste within the same worksheet with no problems.
I can use the clipboard to perform the copy and paste, but the problem with that is that it pastes the value of a formula, not the formula.
I have noticed a similar problem in workbooks where my boss put some VBA code in to highlight the first and top cells of the column and row you are in. In that case, when you go back to the copied cell it is no longer in copy status. In these workbooks I can still copy within the same sheet with no problem.
Thank you in advance for any help that anyone can provide. I am an intermediate user and don't know much VBA, so please be patient if the answer is complicated and I have to ask more questions.