Worksheet Problem
 

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.

Worksheet Problem
 

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"dwake" wrote:

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.

Worksheet Problem
 

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

--


Gary Keramidas
Excel 2003


"dwake" wrote in message
...
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.