PDA

View Full Version : Change cell color after using copy command



abhi_shek
07-03-2012, 06:43 AM
Hi Guys,
I need your help here. :dunno..I have a excel sheet in which I want that whenever a copy command is used on the cell than that cell font or color changes.:doh:

Please I need ur help :help

Kenneth Hobs
07-03-2012, 07:30 AM
Welcome to the forum!

There is no copy event to capture that. We can watch for change events to where it might be pasted. We could use the Selection event to do it for a selection but then if the selection changes, one has to rewrite the last selection which can lead to unexpected changes for the user.