Remove Sheet Disabled

I was recently working on answering this question where in the process of solving it I taught myself how to modify the Excel ribbon XML. My testing may have had unintended consequences because now in every workbook I open, even a brand new one, the 'Remove Sheet" command is disabled as shown below for all sheets. It may be that my testing had nothing to do with the problem but does anyone have any idea how to fix this?
Disabled
LVL 53
Martin LissOlder than dirtAsked:
Who is Participating?
 
Wayne Taylor (webtubbs)Commented:
No. You can only remove general modules, class modules and userforms from the VBE. Worksheets and ThisWorkbook cannot be removed here.
0
 
Wayne Taylor (webtubbs)Commented:
I wasnt aware you could remove Worksheets from the VBE, only from the Excel interface.
0
 
Martin LissOlder than dirtAuthor Commented:
Does the option appear in your VBE?
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
Martin LissOlder than dirtAuthor Commented:
Hmm. I wonder what I did to cause it to be there?
0
 
Wayne Taylor (webtubbs)Commented:
Sorry, I meant that the option is disabled. It is still visible, but greyed out.
0
 
Roy CoxGroup Finance ManagerCommented:
The option is listed in the VBE menu but not functional on my PC. Maybe it's a remnant from older versions,. I thought maybe to remove Macro Sheets, but after checking it doesn't list Macro Sheets.
0
 
Wayne Taylor (webtubbs)Commented:
It has never been available for any Excel objects (worksheets, workbooks, etc). It can only remove VB objects as I mentioned above.
0
 
Martin LissOlder than dirtAuthor Commented:
Thanks. I guess I put 2 and 2 together and got 5.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.