Help! Lost sheets by using View Code on worksheet tab

[Michele]

I have a multi-sheet worksheet for tracking vacation and sick time for our
team. I copied it to the 2007 year name and was updating it for the coming
year.
There are sheets for each month, a Totals sheet, and another sheet which
holds data for calculations, but I don't want anyone to access/change the
data on the calculations sheet.

I 'found' a new functionality; on the sheet tab, right click, select View
Code, and it brings up Microsoft Visual Basic windows. One of those windows
has "Properties - Sheet "(sheetname) and the last of those properties is
"Visable". I selected
"0 - xlSheetHidden" thinking it would effectively 'hide' that one worksheet.
That sheet and two others disapeared from my tabs list. And I can't find
them to get them back.

Any help?

 

[Roger Govier]

Hi Michelle

Try
Format>Sheet>Unhide
You should see a list of the hidden sheets. Just select each one to be
unhidden.

 

[Gord Dibben]

Format>Sheet>Unhide.

If you actually used 2-xlVeryHidden you will have to unhide using code or hit
ALT + F11 and CTRL + r

Expand your workbook/project and from the list of sheets select each sheet that
was hidden and View>Properties and change to 1-xlSheetVisible


Gord Dibben MS Excel MVP

 

[SteveW]

Return the the previous copy of the file.

You did make a copy before you played with the newly found features didn't
you

Otherwise use the tips the others posted.

But next time, make a copy of the file and try it on the copy

Steve