Results 1 to 4 of 4

How to Enable Right Click Insert Command

Threaded View

  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.

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