P priyanshu New Member Mar 31, 2013 #1 Hi, Is there anyway to disable Drag and drop in the unprotected cells, except VBA. Microsoft says no. I would be grateful, if you have a solution. Thanks..
Hi, Is there anyway to disable Drag and drop in the unprotected cells, except VBA. Microsoft says no. I would be grateful, if you have a solution. Thanks..
Debraj Excel Ninja Mar 31, 2013 #2 Hi Priyanshu.. YES.. it s very simple.. * Detach your MOUSE / disable your TOUCHPAD.. Now no one can DRAG & DROP any unprotected cell.. and you dont have to use any VBA also.. PS: JOYSTICKS are very costly.. if you still have one.. then.. above technique will fail.. Regards, Deb
Hi Priyanshu.. YES.. it s very simple.. * Detach your MOUSE / disable your TOUCHPAD.. Now no one can DRAG & DROP any unprotected cell.. and you dont have to use any VBA also.. PS: JOYSTICKS are very costly.. if you still have one.. then.. above technique will fail.. Regards, Deb
bobhc Excel Ninja Mar 31, 2013 #3 Good day Debraj Roy Your answer did one thing that is in short supply world wide...it raised a smile...in my case a big smile. Why the new badge?
Good day Debraj Roy Your answer did one thing that is in short supply world wide...it raised a smile...in my case a big smile. Why the new badge?
Debraj Excel Ninja Mar 31, 2013 #4 Hi Bobhc.. Good Day my friend.. Why the new badge!!! DELL tried to SUE me and they have my address.. and Hawlett-Packard still don't have my address.. Regards, Deb
Hi Bobhc.. Good Day my friend.. Why the new badge!!! DELL tried to SUE me and they have my address.. and Hawlett-Packard still don't have my address.. Regards, Deb