none
How To Show Standard VBA Toolbars and Menubar in Excel 2013/2016 VBA IDE for Macintosh? RRS feed

  • Question

  • How To Show Builti-in Toolbars and Menubar in Excel 2016 VBA IDE for Macintosh?

    For example, Menubar include Debug and Run menus. 

    it's probably the same as 2013 Mac.

    thx

    • Edited by johny w Saturday, March 19, 2016 5:44 PM
    Tuesday, March 15, 2016 9:10 AM

All replies

  • >>>How To Show Toolbars and Menubar in Excel 2016 VBA IDE for Macintosh?

    it's probably the same as 2013 Mac.<<<

    The commands for recording, creating, and deleting macros are available on the Developer tab on the Ribbon.

    If the Developer tab is not available, do the following to display it:

    On the Excel menu, click Preferences > View. And then under In Ribbon, Show, check Developer tab.

    For more information, click here to refer about Create or delete macro in Excel 2016 for Mac

    This is the forum to discuss questions and feedback for Excel for Developers, so I suggest that you could post your question to Microsoft Community

    http://answers.microsoft.com/en-us

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. 

    Thanks for your understanding.
    Wednesday, March 16, 2016 7:12 AM
  • you did not answer the question. 

    are you saying the "Microsoft Office for Developers  >  Excel for Developers" forum is the WRONG place to submit questions concerning Microsoft Office for Developers  >  Excel for Developers?

    thx

    Friday, March 18, 2016 8:56 PM
  • Re:  Excel toolbars and menubars

    With Windows...
     Up thru Xl2010, one could create menubars and toolbars with VBA,
       with Office 2013, MS effectively killed Application.CommandBars code.
     What you can get to work, is not reliable, as the single document interface(SDI) opens a new window for each workbook.
     The new window has a separate Ribbon and menu.

    I view it as just another way to force a separation between old and new Excel versions (and kill VBA) without admitting it.
    (the Ribbon is programmed using xml)
    I doubt if the Macintosh versions are any different.

    '---
    Jim Cone
    Portland, Oregon USA
    https://goo.gl/IUQUN2 (Dropbox)
    (free & commercial excel add-ins & workbooks)

    • Edited by James Cone Tuesday, November 1, 2016 2:16 AM
    Friday, March 18, 2016 11:20 PM
  • hi Jim, thx for this very useful info!

    but, it doesn't answer the question i'm asking. 

    I want to display the standard, built-in VBA menubar and toolbars on Mac Office 2016. 

    The Win VBA menubar contains the Debug and Run menus. 

    Saturday, March 19, 2016 5:43 PM
  • Re:  answering a question

    Well, I read what I wanted to read, not what you actually wrote.
    But, I did feel better after my response. <g>

    I know very little about Mac Office.  Suggest you go to the MS Mac forum to ask your question...
    http://answers.microsoft.com/en-us/mac/forum/macexcel?
    or
    http://answers.microsoft.com/en-us/search/search?SearchTerm=visual+basic+editor&IsSuggestedTerm=false&tab=&x=0&y=0&CurrentScope.ForumName=mac&CurrentScope.Filter=macexcel&ContentTypeScope=#/mac/macexcel//1

    '---
    Jim Cone
    Portland, Oregon USA


    • Edited by James Cone Tuesday, November 1, 2016 2:17 AM
    Saturday, March 19, 2016 6:01 PM
  • Well, I read what I wanted to read, not what you actually wrote.
    But, I did feel better after my response. <g>

    heh! you might have read what i wrote-- i revised my OP slightly, since it was not getting understood. 

    thx for links!

    Saturday, March 19, 2016 7:40 PM