Remove Sheet Greyed Out in VBA Editor

I have a spreadsheet where I am trying to remove an object in the VBA editor but Remove Sheet is greyed out. After a little bit of frustration and searching I got the bright idea to create a brand new spreadsheet from scratch and try to remove a sheet again. Same results, Remove Sheet is greyed out.

Screenshot 2023-02-16 155359.png

What am I doing wrong?

Thank you. The reason why I went down this path is because I have a workbook where the best I can explain, somehow Excel converted one of the worksheets I deleted to a workbook instance(?).
For the life of me I can't figure out how to remove it. Any ideas?

Screenshot 2023-02-16 170245.png

I ran in to a problem where Excel won’t let me copy sheets with tables in them. Unfortunately that’s a high number of worksheets. Is there a trick to copying them?

{Facepalm} You know they say you learn something new every day?

Hi there,

Here's a suggestion that won't take to long to try, and just might solve the problem: move the used rows & columns of your "problem" worksheet to a new worksheet and then delete the "problem" worksheet.

Worth a try? Hope it helps.

Regards,

Greg M

Originally Posted by Greg M

Hi there,

Here's a suggestion that won't take to long to try, and just might solve the problem: move the used rows & columns of your "problem" worksheet to a new worksheet and then delete the "problem" worksheet.

Worth a try? Hope it helps.

Regards,

Greg M

The problem wasn’t with my first example, the problem was in my second file. What was once a worksheet somehow became a workbook object in the file when I deleted it. It would no longer open as a worksheet and it somehow took the properties of ThisWorkbook. So if I changed the name of it, it would change the name of ThisWorkbook! It was very odd. Never saw that before.

Hi again,

Thanks for that interesting information.

The following code might be useful if you wish to move all of your worksheets to a new workbook:

Please Login or Register  to view this content.

Hope this helps.

Regards,

Greg M