Results 1 to 2 of 2

Thread: hide worksheet menu Excel

  1. #1

    Thread Starter
    PowerPoster
    Join Date
    Aug 2003
    Location
    Edinburgh, UK
    Posts
    2,773

    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

    MVP 2007-2010 any chance of a regain?
    Professional Software Developer and Infrastructure Engineer.

  2. #2

    Thread Starter
    PowerPoster
    Join Date
    Aug 2003
    Location
    Edinburgh, UK
    Posts
    2,773

    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

    MVP 2007-2010 any chance of a regain?
    Professional Software Developer and Infrastructure Engineer.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width