Problem with Excel 2007

  • Thread starter Thread starter albertmb
  • Start date Start date
A

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
 
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

p45cal said:
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
Click to expand...



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

.
Click to expand...
 
Back
Top