ChgsAllAround
New Member
- Joined
- Apr 11, 2008
- Messages
- 36
I am using the worksheet_selectionchange macro. I noticed that if you refer to any other cell than the one that is the "target" cell, the Paste option is greyed out. This means that for the person using the worksheet, paste is never available. Is there a way of getting around this? I've tried both direct code inside of the macro and calls to other subs--neither works. I'm guessing that it's related to the fact the the macro is essentially using the excel clipboard to keep track of the content of the target, but that's not very helpful to the end-user. Any suggestions? Thanks