Problem with Excel 2007

[albertmb]

Hi Everyone, It is my first time working on Excel 2007. I was working on a
project which I started on Excel 2003, I opened another project for reference
and when I returned to the first project all sheets disappeared. The only
accessible buttons on the toolbar are the Macro buttons. All macros are
still there and sheet names in the VBA are still there. Did I loose my work?

Thanks to all

 

[p45cal]

Hi Everyone, It is my first time working on Excel 2007. I was workin
on a

project which I started on Excel 2003, I opened another project fo reference
and when I returned to the first project all sheets disappeared. Th only
accessible buttons on the toolbar are the Macro buttons. All macro are
still there and sheet names in the VBA are still there. Did I loose m work?

Thanks to all

Since "sheet names in the VBA are still there", click on one to selec
it, make sure the properties are visible (F4), at the bottom of th
Properties pane when showing the 'Alphabetic' tab, you should se
'Visible'; change its property to '1-xlSheetVisible'. Repeat for othe
invisible sheets.

 

[albertmb]

hi p45cal, Thank you for your kind concern but it was not the problem, on
having a better look there was another functional button in the view menu
'UNHIDE' apparently I hid the whole workbook without knowing.

Thank you once again

Albert

Hi Everyone, It is my first time working on Excel 2007. I was working
on a

project which I started on Excel 2003, I opened another project for reference
and when I returned to the first project all sheets disappeared. The only
accessible buttons on the toolbar are the Macro buttons. All macros are
still there and sheet names in the VBA are still there. Did I loose my work?

Thanks to all

Since "sheet names in the VBA are still there", click on one to select
it, make sure the properties are visible (F4), at the bottom of the
Properties pane when showing the 'Alphabetic' tab, you should see
'Visible'; change its property to '1-xlSheetVisible'. Repeat for other
invisible sheets.


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: 558
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=183433

Microsoft Office Help

.