Orphan worksheet

[ijourneaux]

I have a workbook that has a a lot of VBA code. In normal use of the spreadsheet, Excel creates orphan worksheets. In the screen capture below, 2 of the VBA worksheets Sheet17 and Sheet 25 get duplicates, Sheet171 and Sheet251. The VBA code in each of these sheets stays in the original module but the actual sheet layout is in new duplicate worksheets. Over time I will get additional duplicate worksheet sheet17, Sheet171, Sheet 1711, Sheet17111, etc.
I am trying to understand why this is happening. The extra worksheets can not be deleted. The only fix appears to be saving as at .xlsx, and copying over all of the code and then saving back as a xlsm.

Appreciate any thoughts or comments
Ian

 

[RainerGaier]

Hi Ian,

I see your issue about Orphaned Worksheets is more than a year old. I am having the same issue and was wondering if you found the cause and how to remedy it?

Appreciate any help as I have a massive Workbook with tons of code. I'm also very keen to know the root cause.

Thanks
Rainer

 

[ijourneaux]

Unfortunately I did not find an answer

 

[RainerGaier]

Yeah, I've gathered that the remedy is to migrate all the sheets and modules to a new worksheet. Not great hey, especially if the root cause has not been figured out.
Thanks for replying so promptly.