<div>
I wasnt aware you could remove Worksheets from the VBE, only from the Excel interface.
</div>


I wasnt aware you could remove Worksheets from the VBE, only from the Excel interface.

<div>
Does the option appear in your VBE?
</div>


<div>
Hmm. I wonder what I did to cause it to be there?
</div>


Hmm. I wonder what I did to cause it to be there?

<div>
Sorry, I meant that the option is disabled. It is still visible, but greyed out.
</div>


Sorry, I meant that the option is disabled. It is still visible, but greyed out.

<div>
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.
</div>


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.

<div>
It has never been available for any Excel objects (worksheets, workbooks, etc). It can only remove VB objects as I mentioned above.
</div>


It has never been available for any Excel objects (worksheets, workbooks, etc). It can only remove VB objects as I mentioned above.

<div>
Thanks. I guess I put 2 and 2 together and got 5.
</div>


Thanks. I guess I put 2 and 2 together and got 5.

<div>
<div class="content wysiwyg-content">
I was recently working on answering <a href="https://www.experts-exchange.com/questions/28659249/How-to-Disable-Enable-any-worksheet's-selected-right-click-menu-items.html" rel="ugc">this question</a> 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&quot; 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?<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/04_w17/910611/Cursor-and-Project-Window.jpg" target="_blank" title="Disabled (148 KB)"><img alt="Disabled" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2015/04_w17/800_910611/Cursor-and-Project-Window.jpg" /></a>
</div>
</div>


Cursor-and-Project-Window.jpg

I was recently working on answering this question (https://www.experts-exchange.com/questions/28659249/How-to-Disable-Enable-any-worksheet's-selected-right-click-menu-items.html) 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?


Remove Sheet Disabled

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.