Do we really like limitations..??

  • Article

No, We don't ..!! its once again proved by  maarten have a look at this blog where he tells you how to remove convert the Clasic Worksheet to Extended Worksheet, https://blogs.officezealot.com/maarten/archive/2005/06/08/4673.aspx and whats more if you have any confussion on how to convert it to VB .NET maarten comes back again to hold your hand https://blogs.officezealot.com/maarten/archive/2005/09/12/7979.aspx, i guess i have a question for VSTO devs, if this was possible why we don't have an easier way to do it, and the the more important point here is the code we are using here looks scary, like for example  Me.VBProject.VBComponents.Item(1) is a pure workaround just to refresh the VBProjects associated with the workbook or when your try to search for help on New Microsoft.Office.Tools.Excel.Worksheet(hostprovider, RuntimeCallback, workSheet.CodeName, Microsoft.VisualBasic.Constants.vbNull, workSheet.Name) search Tools.Excel.Worksheet in MSDN and you will know that "Worksheet host items cannot be created programmatically. For more information, see Worksheet and Host Items and Host Controls Overview." but it still works...!! anyway i am happy maybe its a big question for VSTO guys