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?
Bookmarks