Losing all subsequent tabs in my files....please help!

[exceldata]

I've been working with a lot of data, many tabs, and macros in my excel worksheets, and I've recently lost all of the tabs that were in the sheet except for the first/original tab. This has happened twice on two different worksheets - I save it, close it, and when I reopen it, all the tabs have disappeared.

What am I doing wrong? Could anyone help me to restore my information, or at least prevent it from happening again?

Thanks very much.

 

[Fluff]

Do you have any code the ThisWorkbook module?

 

[exceldata]

I'm not sure that I know how to check what you are asking. I did notice that the names of the macros changed to something like a different worksheet reference, and that happened just before I saved, closed out, and opened it back up to find the tabs gone.

 

[Fluff]

If you go into the VB Editor (Alt F11 will open it), look at the Project window (usually top left of the editor) are all the sheets listed?

 

[SpillerBD]

If they are hidden, and you've found the VBE (visual Basic Editor), you might consider this snippet to add to the Personnel Macro Workbook.
Then add it to the QAT to keep it handy.

Sub UNhideAll_WorkSheets()
Dim sht As Worksheet
    For Each sht In ActiveWorkbook.Worksheets: sht.Visible = True
    Next sht
End Sub

 

[exceldata]

I found the VBE, but I don't see the sheets listed anywhere. Just Sheet 1...

 

[exceldata]

I think I've found the issue. Unfortunately, I saved these two files as CSV. Is there any way to get my tabs back at this point??

 

[Fluff]

As long as the two files were originally .xlsm (or similar) files, then the sheets should still be in the original workbooks.