+ Reply to Thread
Results 1 to 9 of 9

Events if ribbon is hidden or visible

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Events if ribbon is hidden or visible

    Hello everyone
    Is there an event related to the ribbon is hidden or visible?
    That is if ribbon is hidden then value in A1 is 0 and if it is visible then value in A1 is 1

    Thanks a lot for advanced help
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  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: Events if ribbon is hidden or visible

    There is no event associated with hiding the ribbon.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Events if ribbon is hidden or visible

    Quote Originally Posted by shg View Post
    There is no event associated with hiding the ribbon.
    Nor workaround to solve such issue ..?!

  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: Events if ribbon is hidden or visible

    Windows API can do anything. Reckon it depends how deep you want to dig.

  5. #5
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Events if ribbon is hidden or visible

    Quote Originally Posted by shg View Post
    Windows API can do anything. Reckon it depends how deep you want to dig.
    So there is a hope.
    Let's do this simple steps ..
    ==================
    if ribbon is hidden then value in A1 is 0 and if it is visible then value in A1 is 1

  6. #6
    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: Events if ribbon is hidden or visible

    I'll leave you to it. Good luck.

  7. #7
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Events if ribbon is hidden or visible

    Quote Originally Posted by shg View Post
    I'll leave you to it. Good luck.
    But I have no experience in API programming .. If you have time to help me I appreciate that a lot

  8. #8
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,441

    Re: Events if ribbon is hidden or visible

    You can use the MinimizeRibbon command in ribbonx to detect when it is clicked and then determine the ribbons height to know whether it's being displayed or not.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  9. #9
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Events if ribbon is hidden or visible

    Thank you very much Mr. Andy
    That's exactly what I was searching for
    Best Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Controls Visible or Hidden
    By laguna92651 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2014, 02:07 AM
  2. [SOLVED] Format all cells in all sheets to Protection Hidden on visible and hidden tabs
    By DeRo22 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-28-2014, 03:17 PM
  3. Replies: 4
    Last Post: 01-06-2014, 02:14 AM
  4. Combo Box visible when it should be hidden
    By are_cloud7 in forum Excel General
    Replies: 0
    Last Post: 05-09-2012, 12:16 AM
  5. Making a Hidden App Visible
    By SDruley in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-21-2011, 06:57 PM
  6. Is Hidden the Same as Not Visible?
    By leaning in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2011, 11:47 AM
  7. Why does VBA have Visible and Hidden properties?
    By davegugg in forum The Water Cooler
    Replies: 2
    Last Post: 08-17-2010, 05:36 AM

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