locked
VSTO 2005 : Prevent Vertical Drag drop in a particular excel work sheet RRS feed

  • Question

  • Hi,

    I am using VSTO 2005 . I want to prevent vertical drag drop(inter column)  in a specific work sheet and display a message box when any one tries to do a vertical drag drop within the specified work sheet. But drag drop should work in all other work sheets. Also the specified work sheet should support horizontal drag drop( inter row).

    Is there anyway by which I can achieve this in VSTO 2005?

    Thanks

    Thursday, April 5, 2012 6:11 AM

Answers

  • Hi SandyXYZ,

    Thanks for posting in the MSDN Forum.

    It's based on my experience you need invoke Win32 API to solve your issue. It's based on my experience this issue will not solved via PIA.

    If you have any questions, please feel free to let me known.

    Have a good day,

    Tom


    Tom Xu [MSFT]
    MSDN Community Support | Feedback to us

    • Proposed as answer by 许阳(无锡) Wednesday, April 11, 2012 4:56 AM
    • Marked as answer by 许阳(无锡) Thursday, April 12, 2012 3:03 AM
    Monday, April 9, 2012 6:01 AM

All replies

  • Hi SandyXYZ,

    Thanks for posting in the MSDN Forum.

    It's based on my experience you need invoke Win32 API to solve your issue. It's based on my experience this issue will not solved via PIA.

    If you have any questions, please feel free to let me known.

    Have a good day,

    Tom


    Tom Xu [MSFT]
    MSDN Community Support | Feedback to us

    • Proposed as answer by 许阳(无锡) Wednesday, April 11, 2012 4:56 AM
    • Marked as answer by 许阳(无锡) Thursday, April 12, 2012 3:03 AM
    Monday, April 9, 2012 6:01 AM
  • Hi SandyXYZ,

    Thanks for posting in the MSDN Forum.

    It's based on my experience you need invoke Win32 API to solve your issue. It's based on my experience this issue will not solved via PIA.

    If you have any questions, please feel free to let me known.

    Have a good day,

    Tom


    Tom Xu [MSFT]
    MSDN Community Support | Feedback to us

     I would like to know which win32 API will be invoked
    Wednesday, November 16, 2016 9:20 AM