hide worksheet menu Excel
I am working on a project which embeds an Excel app. Thats all fine.
Problem is, when I try to hide the Application's Worksheet menu bar, it throws a COM Exception and that's it, it won't go further than that :(
how can I disable or hide the menu bar in the embedded Excel app?
using Excel 2003 API. The code to hide the menu bar is as follows:
this._excelApplication.CommandBars["Worksheet Menu Bar"].Visible = false;
Thanks
Re: hide worksheet menu Excel
hmmm seemed to have got it to work. it should be done just after you make the instance of the excel application.....interesting