Excel and some disappeared sheets - PLS HELP!!!

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


"juma68" <juma68@gmail.com> wrote in message
news:1149499443.560841.317620@g10g2000cwb.googlegroups.com...
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

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.

------------------------------------------
Norman Jones nap=EDsal(a):
> 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
>
>
> "juma68" <juma68@gmail.com> wrote in message
> news:1149499443.560841.317620@g10g2000cwb.googlegroups.com...
> 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=B4t 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=B4t know since I ask anybody for help
>=20
> Thanks in advance
>=20
> Juraj
> juma68atgmail.com

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



"juma68" <juma68@gmail.com> wrote in message
news:1149501087.792668.134220@g10g2000cwb.googlegroups.com...
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.

------------------------------------------
Norman Jones napísal(a):
> 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
>
>
> "juma68" <juma68@gmail.com> wrote in message
> news:1149499443.560841.317620@g10g2000cwb.googlegroups.com...
> 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

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.

----------------------------------------------
Norman Jones nap=EDsal(a):
> Hi Juma,
>
> Copy the following code:
>
> '=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D>>
> 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 =3D xlSheetVisible
> Next SH
>
> End Sub
> '<<=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>
> 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
>
>
>
> "juma68" <juma68@gmail.com> wrote in message
> news:1149501087.792668.134220@g10g2000cwb.googlegroups.com...
> 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.
>
> ------------------------------------------
> Norman Jones nap=EDsal(a):
> > 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
> >
> >
> > "juma68" <juma68@gmail.com> wrote in message
> > news:1149499443.560841.317620@g10g2000cwb.googlegroups.com...
> > 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=B4t 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=B4t know since I ask anybody for help
> >
> > Thanks in advance
> >
> > Juraj
> > juma68atgmail.com