Worksheet Problem

[dwake]

So I have a couple of issues.

I go to open up a file today and try to unhide two worksheets that were
hidden, and they are gone. I can still see them in VBA, but cannot open them
and they are not visible at all in excel.

I also am having trouble inserting a new worksheet. All the options are
they, but I am not able to select insert.

Any help would be appreciated.

 

[Luke M]

CHeck to see if workbook protection is activated. That would prevent you from
being able to add new sheets (or unhide). Also, in VBE, check to see if the
missing sheets have a visible status of "xlSheetVeryHidden". In this state,
you can't see the sheet from XL. Change it to either xlSheetVisible or
xlSheetHidden.

 

[Gary Keramidas]

select the sheet in vb, then check the properties (F4) and see what the visible
property is set to.