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 56
Martin LissOlder than dirtAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
OWASP: Forgery and Phishing

Learn the techniques to avoid forgery and phishing attacks and the types of attacks an application or network may face.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.