Results 1 to 5 of 5

customize users ribbon (like in excel options) upon open/activation

Threaded View

  1. #1
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    customize users ribbon (like in excel options) upon open/activation

    Hello,



    I know I can customize my ribbon through the excel options, but how to I do it programatically? I was hoping to find some code to add to the workbook_open, workbook_activation events to do the following:

    Upon open or activation the workbook - hide all the usual Excel ribbon areas and show only the special one that was made for said workbook.

    Upon close or deactivation of this same workbook - let the ribbon return to the normal state.

    Thank you
    Last edited by GeneralDisarray; 09-25-2014 at 01:18 PM. Reason: solved the issue
    Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Unable to Customize Ribbon
    By bkm2016 in forum Excel General
    Replies: 9
    Last Post: 07-14-2014, 11:18 AM
  2. [SOLVED] Customize Ribbon Code. Need Help!
    By Hooty in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2013, 12:45 PM
  3. [SOLVED] Customize Excel Ribbon When File Opens
    By amotto11 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-06-2013, 04:04 PM
  4. Customize Ribbon (Add Button / Assign Macro) in Excel 2010
    By JMax in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2012, 04:46 PM
  5. Need help for Customize Excel Ribbon macros
    By Tareq87 in forum Excel General
    Replies: 6
    Last Post: 05-06-2012, 12:32 PM

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