dcsimg
Results 1 to 4 of 4

Thread: HELP! Can't re-enable the Excel ribbon after disabling!

  1. #1

    Thread Starter
    New Member
    Join Date
    Aug 2017
    Posts
    7

    HELP! Can't re-enable the Excel ribbon after disabling!

    HELP! I seem to have locked myself out of my VBA Excel code. I used the following code to disable the ribbon:

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

    That disables the ribbon. But it also no longer shows the icon in the upper right to re-enable the ribbon. So I don't know if there is a way to get to my VBA code now, as I can't see the menu with the "Developer" entry. Is there some other way to get to my code?? Or to re-enable the ribbon??

    Thanks...

  2. #2
    Frenzied Member jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    1,604

    Re: HELP! Can't re-enable the Excel ribbon after disabling!

    Try Alt+F11 to show the VBA window.

  3. #3

    Thread Starter
    New Member
    Join Date
    Aug 2017
    Posts
    7

    Re: HELP! Can't re-enable the Excel ribbon after disabling!

    Yep. I found that. Sorry to bother you! But thanks for the reply. :-)

  4. #4
    Frenzied Member jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    1,604

    Re: HELP! Can't re-enable the Excel ribbon after disabling!


Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width