+ Reply to Thread
Results 1 to 3 of 3

Disable Contents of the Excel Ribbon

  1. #1
    Registered User
    Join Date
    10-28-2021
    Location
    Uganda
    MS-Off Ver
    2013
    Posts
    3

    Disable Contents of the Excel Ribbon

    Hi Everyone?

    I would like to know is there a VBA code that doesn't actually hide the excel ribbon but deactivates all the contents of the ribbon? (Tabs and tools)

    I would like to maintain the excel ribbon on display but make all its contents INACTIVE whenever this particular workbook opens.
    Please help me on that.

    Thanks

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,331

    Re: Disable Contents of the Excel Ribbon

    What's the point of it being visible if you can't use it?
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Registered User
    Join Date
    10-28-2021
    Location
    Uganda
    MS-Off Ver
    2013
    Posts
    3

    Re: Disable Contents of the Excel Ribbon

    It gives some sort of frame to the workbook other than putting it off completely.

+ 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. Disable Items or commands on ribbon in Excel
    By Kelly mort in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-25-2021, 02:21 PM
  2. how to disable buttons on a custom ribbon
    By diego208 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-23-2020, 11:00 AM
  3. Disable Ribbon Keytips
    By abc3132 in forum Excel General
    Replies: 2
    Last Post: 01-10-2019, 07:46 AM
  4. [SOLVED] Disable commands Ribbon excel
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 33
    Last Post: 05-03-2016, 10:24 AM
  5. How to disable the command "Move or Copy ..." Ribbon of Excel 2007?
    By CarlosGrados in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-23-2012, 04:47 PM
  6. Disable Ribbon Tab When No Workbook is Open
    By bambaataa in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-20-2012, 04:34 AM
  7. [SOLVED] Disable commands Ribbon excel 2010
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-04-2012, 08:17 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