+ Reply to Thread
Results 1 to 5 of 5

Excel 2007: Ribbon set to hide, but doesn't before User Form opens.

  1. #1
    Registered User
    Join Date
    09-15-2011
    Location
    Washington, OK
    MS-Off Ver
    Office 2010
    Posts
    23

    Excel 2007: Ribbon set to hide, but doesn't before User Form opens.

    My first post by the way, so here goes.
    I have excel set to open into full screen and hide everything except the title bar.
    I worked perfectly until I added the load userform command into the string.
    I have also tried moving the command into another private sub and running a call macro to load it from another module.
    No matter what I do the userform loads before the ribbon hides.

    Another tips on cleaning up my code are welcome

    My code looks like this:

    Please Login or Register  to view this content.
    Last edited by Casedias; 09-16-2011 at 05:07 PM. Reason: closing code tag is [/code]
    Casey Wells

    Most Appreciative Rookie!

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Excel 2007: Ribbon set to hide, but doesn't before User Form opens.

    Move the line of code that hides the ribbon to be above the line that shows the form. A modal form stops code execution.

    Please change your profile to show the correct version of Excel.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    09-15-2011
    Location
    Washington, OK
    MS-Off Ver
    Office 2010
    Posts
    23

    Re: Excel 2007: Ribbon set to hide, but doesn't before User Form opens.

    Worked perfectly. Thanks so much.
    Also, I changed my profile to reflect the proper versions of excel I am using.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Excel 2007: Ribbon set to hide, but doesn't before User Form opens.

    You're welcome, and thank you.

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Excel 2007: Ribbon set to hide, but doesn't before User Form opens.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ 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