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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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.