+ Reply to Thread
Results 1 to 3 of 3

Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" not working

  1. #1
    Registered User
    Join Date
    02-02-2010
    Location
    Tasmania, Australia
    MS-Off Ver
    Excel 2007
    Posts
    36

    Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" not working

    I am having some frustration in getting this code to work.

    I have a workbook with multiple worksheets.

    The workbook has the following code.

    Please Login or Register  to view this content.
    ....and each worksheet has this code

    Please Login or Register  to view this content.
    ....when the workbook opens its perfect, no ribbon etc, and if you navigate to any of the other worksheets the ribbon stays away. The problem I have is when the workbook is minimized (ie not full screen) for the first time ALL the ribbons/toolbars etc become visible. Once the workbook is made back to fullscreen and I navigate to any of the worksheets the ribbon/toolbars etc disappear and they stay that way even if the workbook is minimized.

    So my problem is how to I make the first instance of minimizing of the workbook NOT make everything (ribbon, toolbars etc) visible. I assume I am missing something?

    I would be more than happy to take away the user option of minimizing the workbook (and for that matter of closing the workbook at all) but have no idea how to do that so any help at all would be very much appreciated.

    Thanks everyone.
    t

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" not working

    probably the only code (in the workbook macromodule)you need is:

    Please Login or Register  to view this content.
    The properties
    '.DisplayHorizontalScrollBar = False
    .DisplayVerticalScrollBar = False
    .DisplayWorkbookTabs = False
    .DisplayGridlines = False
    .DisplayHeadings = False'

    will be stored in the workbook for every sheet, so once you have chosen these properties for each separate sheet, it won't be necessary to use VBA to do that for a second, third, fourth,... etc. time.
    Last edited by snb; 10-31-2011 at 06:25 AM.



  3. #3
    Registered User
    Join Date
    02-02-2010
    Location
    Tasmania, Australia
    MS-Off Ver
    Excel 2007
    Posts
    36

    Re: Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" not working

    Hi SNB

    Thank you for the above code but even with this in place, when the workbook opens it IS in fullscreen and no ribbon but the minute you hit the minimize for the workbook for the first time everything comes back (all the toolbars and the ribbon) and they will then disappear when I navigate to another sheet (as expected) and if I then minimize the workbook again all the toolbars and ribbon remain hidden - my issue is that I cannot stop the first minimize of the workbook from showing the toolbars/ribbon - very frustrating. Any further thoughts?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1