Tom,

The OP doesn't say what did it, wd.Visible = True, or WindowsUnhide (which I first suggested).

I just wonder if there may be a window property that will hide the window from WindowsUnhide, but still make the window accessible from VBA?

Best regards,
Anders Silvén


skrev i meddelandet ...
Tom,

Thanks it worked.

Brian
-----Original Message-----
apparently you have two windows for the workbook, but
one of the windows is
hidden. Make worksheet_name.xls:2 as the active window

in the workbook put this code

sub showWindows
for each wd in ActiveWorkbook.windows
wd.Visible = True
Next
End Sub

and run it

or simply go to the Windows menu and choose unhide, then
select
worksheet_name.xls:1

--
Regards,
Tom Ogilvy

"Brian" wrote in
message
...
When I open a specific Excel workbook, the title bar
shows "Microsoft Excel - worksheet_name.xls:2". There
is
only one worksheet window, why the ":2". If you close
the
worksheet, Excel does not close. There is VBA code
associated with the worksheet which remains open.
I an using Excel 2000 with Windows XP.
Thanks for any help.


.