Hi All:
I want to disable copy and paste if the user does not copy to the same column. It is therefore important that I know which cell she was on when she pressed CTRL-C. In the Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) method, there is reference to the target cell (Target.Cells.Column), but I can't find a ref to the origin cell.
How can I accomplish what I want to do?
Thanks,
Yossi
Maybe?
Please Login or Register to view this content.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Great! Thanks.
If you are happy with the solution please mark the thread as [SOVLED] using the thread tools at the top.
On any thread you can show appreciation to those who have helped you by clicking the * below their post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks