Forum Discussion
daungurait
Feb 08, 2020Copper Contributor
Missing Sheets
Hello, I was working in an excel spreadsheet that was saved as a .xls (97-03) and reorganized the data into multiple separate sheets or pages. I saved it, and upon reopening the file, I had a few...
Subodh_Tiwari_sktneer
Feb 09, 2020Silver Contributor
You will have to make sure that the workbook is not protected, if yes, unprotect it to unhide sheets if any.
If workbook is not protected, to check if the visible property of a sheet is not set to xlSheetVeryHidden and in that case to change the visible property, please follow the instructions shown in the following screenshot.
- daunguraitFeb 09, 2020Copper Contributor
Thanks for the reply, but when I opened the VB editor, it only showed the sheet that I could see. No other sheets showed up, so it looks like all that data was deleted unfortunately. Thanks anyways.