DEAR ALL, in the program I made, i have one sheet which has links to
other sheets which I send to the office. But due to users choice,
sometimes instead of copying the data, they drag and paste. Hence the
links in the company sheet goes off. Can you pls advice how to disable
this drag feature, cut and paste feature and enable only copy and
paste in VB. This particular section of the user is not locked and
for data entry. Last 3 days to go on the ship for me. No time to
study n find out.Pls advice.

Application.CellDragAndDrop = False

is the equivalent of manually doing Tools=Options=Edit Tab and unchecking
allow drag and drop

--
Regards,
Tom Ogilvy

"CAPTGNVR" wrote in message
ups.com...
DEAR ALL, in the program I made, i have one sheet which has links to
other sheets which I send to the office. But due to users choice,
sometimes instead of copying the data, they drag and paste. Hence the
links in the company sheet goes off. Can you pls advice how to disable
this drag feature, cut and paste feature and enable only copy and
paste in VB. This particular section of the user is not locked and
for data entry. Last 3 days to go on the ship for me. No time to
study n find out.Pls advice.

Tom Ogilvy wrote:
Application.CellDragAndDrop = False

is the equivalent of manually doing Tools=Options=Edit Tab and unchecking
allow drag and drop

--
Regards,
Tom Ogilvy

"CAPTGNVR" wrote in message
ups.com...
DEAR ALL, in the program I made, i have one sheet which has links to
other sheets which I send to the office. But due to users choice,
sometimes instead of copying the data, they drag and paste. Hence the
links in the company sheet goes off. Can you pls advice how to disable
this drag feature, cut and paste feature and enable only copy and
paste in VB. This particular section of the user is not locked and
for data entry. Last 3 days to go on the ship for me. No time to
study n find out.Pls advice.


Thank u Tom. I did get some clues from ur guidance. I was not clear
in my post. What I want is to lock this drag n drop for a named range
only thro VB. for ex: b20.aa80.