Excel and some disappeared sheets - PLS HELP!!!

J

juma68

Anybody has the same or similar experiences :

- I worked with excel file / closed as usually
- new day opened and unfortunatelly some very important sheets
disappeared / why ? Don´t know
- I had about 7-9 sheets just now only 3 ones are there but not so
important as another ones
- the file has original size / I quickly looked into file by normal
text editor only for reading
and all relevant data are there, however if I open file by Excel, NO
original sheets or data
are there.
- this file is VERY IMPORTANT for me
- why happened ? Don´t know since I ask anybody for help

Thanks in advance

Juraj
juma68atgmail.com
 
N

Norman Jones

Hi Juma,

Try:

Format | Sheet | Unhide

Repeat the operation for each sheet listed there.

If no sheets are listed, try:

Windows | Arrange| Tiled


---
Regards,
Norman


Anybody has the same or similar experiences :

- I worked with excel file / closed as usually
- new day opened and unfortunatelly some very important sheets
disappeared / why ? Don´t know
- I had about 7-9 sheets just now only 3 ones are there but not so
important as another ones
- the file has original size / I quickly looked into file by normal
text editor only for reading
and all relevant data are there, however if I open file by Excel, NO
original sheets or data
are there.
- this file is VERY IMPORTANT for me
- why happened ? Don´t know since I ask anybody for help

Thanks in advance

Juraj
juma68atgmail.com
 
J

juma68

No chance to unhide sheets in a menu Format / Sheets / Unhide - it is
not
active. There are perhaps hidden sheets or what status they have and I
need them to be visible, but still not solved problem, yet. Thanks
Norman for info but still pending problem.
 
N

Norman Jones

Hi Juma,

Copy the following code:

'=============>>
Public Sub Tester()
Dim SH As Worksheet

MsgBox "There are " & ThisWorkbook.Sheets.Count _
& " worksheets in this workbook"
For Each SH In ThisWorkbook.Worksheets
SH.Visible = xlSheetVisible
Next SH

End Sub
'<<=============

Alt-F11 to open the VBE (visual basic editor)
Menus | Insert Module
Paste the above code into the (now) open module
With the cursor anywhere within the pasted code, hit F5 to run the code.
Alt-F11 to return to Excel.

How many sheets are reported by the message box?

If the reported number of sheets is what you expect, are the now visible?


---
Regards,
Norman


--
---
Regards,
Norman



No chance to unhide sheets in a menu Format / Sheets / Unhide - it is
not
active. There are perhaps hidden sheets or what status they have and I
need them to be visible, but still not solved problem, yet. Thanks
Norman for info but still pending problem.
 
J

juma68

Thanks for your help, used it and got answer 3 sheets. However all data
are still
in my file, I can see them via notepad view and the size is still 27 MB
however I cannot retriev all data into sheets.
 
Top