none
workbook opened event/sheets activated event vsto RRS feed

  • Question

  • Hi All,

    • I want to execute some code using VSTO in excel workbook after rendering the excel without any manual intension .
    • How to know whether sheet is activated or not?
    • If we add any validation combo control to the shee some  which is not activated, will it give any proble? if so, what is alternative approach.
    • When we are creating validation combo on multiple sheets after button click ( rendered on task pane ), it is giving error . This is happening after opening excel. Is it because of sheet is not yet activated? How to activate sheet without moving to that sheet and add validation combo
    Thursday, April 4, 2013 5:10 PM

Answers

  • Hi Myowntest,

    Thank you for posting in the MSDN Forum.

    >How to know whether sheet is activated or not?

    You can refer to Worksheet.Activate Event (Excel).

    >If we add any validation combo control to the shee some  which is not activated, will it give any proble?

    Validation is a member of a Range object. I think you can add data validation to a Range even it's in an inactive sheet.

    >When we are creating validation combo on multiple sheets after button click ( rendered on task pane ), it is giving error . This is happening after opening excel. Is it because of sheet is not yet activated? How to activate sheet without moving to that sheet and add validation combo

    You can create a sample project that reproduces your scenario and upload it to SkyDrive and then share to us.

    Best regards,


    Quist Zhang [MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Monday, April 8, 2013 1:30 PM
    Moderator