Jac,

You probably have a Very Hidden Sheet.

Go into the VBE. In the project window every worksheet in the workbook will
be listed here. Find the one that does not have a worksheet tab in Excel.
Back in VBE, in the project window, click on the missing Sheet. Now look at
the Properties window, the Visible attribute is either xlSheetHidden or
xlSheetVeryHidden. Change it to xlSheetVisible.

"Jac Tremblay" wrote:

A little more on this question...

I figured that there is a difference between "Sheets" and "Worksheets". Ok.
But, now, there are 10 sheets and 9 worksheets. So where is the 10th sheet?
How do I display it or, if this is not possible, how do I get to know what it
is? What type of sheet?

Thanks.

"Jac Tremblay" wrote:

Hi everyone,

When I execute the code: "ActiveWorkbook.Sheets.Count", I get 10 while there
are only 9. The workbook and the sheets are not password protected and there
are no hidden sheets either.

I am using Excel XP and Windows XP.

What could the problem be?
--
Jac Tremblay