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

exceldata

New Member
Joined
Mar 2, 2016
Messages
44
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.
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Do you have any code the ThisWorkbook module?
 
Upvote 0
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.
 
Upvote 0
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?
 
Upvote 0
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.

Code:
Sub UNhideAll_WorkSheets()
Dim sht As Worksheet
    For Each sht In ActiveWorkbook.Worksheets: sht.Visible = True
    Next sht
End Sub
 
Upvote 0
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??
 
Upvote 0
As long as the two files were originally .xlsm (or similar) files, then the sheets should still be in the original workbooks.
 
Upvote 0

Forum statistics

Threads
1,213,504
Messages
6,114,016
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top