+ Reply to Thread
Results 1 to 4 of 4

How to Enable Right Click Insert Command

  1. #1
    Registered User
    Join Date
    02-06-2013
    Location
    nunya
    MS-Off Ver
    Excel 2010
    Posts
    9

    How to Enable Right Click Insert Command

    I have inadvertently disabled the right click cell formatting options: insert, delete, and clear contents. I am not sure what I have done to disable these options, but I would appreciate some help enabling them again. I have been writing VBA code for a project and had protected several worksheets with passwords and then inserted this code to disable the unhide feature:
    Application.CommandBars("Worksheet Menu Bar").Controls("F&ormat").Controls("S&heet").Controls("&Unhide...").Enabled = False

    I ran the code and then decided to simply use the sheet protection so I ran it again changing the "false" to a "true" to enable the feature. I have since unprotected all sheets, but am still unable to use the right click insert and delete options. However they still work in the ribbon. Any ideas?
    Last edited by thoseguys; 02-27-2013 at 07:30 PM.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: How to Enable Right Click Insert Command

    that code is for a different menu. the cell right click menu is
    Please Login or Register  to view this content.
    but note there are actually two Cell menus
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    02-06-2013
    Location
    nunya
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: How to Enable Right Click Insert Command

    Thank you very much sir! You are a life-saver, that works perfectly and now I can continue my work at ease.

  4. #4
    Registered User
    Join Date
    09-22-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Thumbs up Re: How to Enable Right Click Insert Command

    Awesome reset line - helped me a great deal. I disabled for a row on one spreadsheet but didn't turn back on for others.
    Thanks greatly

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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