Excel Worksheets
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.
.
|