Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Worksheets
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Worksheets
Brian,
the "xls:2" means that there is indeed another window. Maybe it is hidden. Try WindowUnhide (I think it's called that). Then close one of the windows, save the file and you'll be OK, HTH Anders Silvén "Brian" skrev i meddelandet ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Worksheets
Anders,
It is not due to a hidden worksheet. I unhid all hidden worksheets to check. If you select "Windows" on the menu bar the drop down menu only shows one worksheet, which if selected is "xls:2". Thanks, Brian -----Original Message----- Brian, the "xls:2" means that there is indeed another window. Maybe it is hidden. Try WindowUnhide (I think it's called that). Then close one of the windows, save the file and you'll be OK, HTH Anders Silvén "Brian" skrev i meddelandet ... 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. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Worksheets
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Worksheets
Hmmm...
Beats me what it is. Let's hope for the gurus to cut in :) Anders "Brian" skrev i meddelandet ... Anders, It is not due to a hidden worksheet. I unhid all hidden worksheets to check. If you select "Windows" on the menu bar the drop down menu only shows one worksheet, which if selected is "xls:2". Thanks, Brian -----Original Message----- Brian, the "xls:2" means that there is indeed another window. Maybe it is hidden. Try WindowUnhide (I think it's called that). Then close one of the windows, save the file and you'll be OK, HTH Anders Silvén "Brian" skrev i meddelandet ... 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. . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Worksheets
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to save modified Excel 2003 worksheets using Excel 2007 | Excel Discussion (Misc queries) | |||
How use info in Excel shared worksheets to create new worksheets | Excel Worksheet Functions | |||
Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file | Excel Discussion (Misc queries) | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) | |||
Need code to protect worksheets - amount of worksheets varies | Excel Programming |