xl2kpro & xl'03 One workbook has the split is turned on permanently.
The option in the Window drop down says "Split" but the split slider on the vertical
scroll bar still shows.
This workbook is shuffled between work (xl'03) and home (xl2kpro) and, at work I used the
"Compare side by side" option which may have triggered this problem.
--
Regards;
Rob
------------------------------------------------------------------------
RE: How do break the link from my excel workbook to a access database. ... This one is safer because you get to look at each query as ... The following is for 'QueryTables' or queries embedded in the worksheet: ... Do this on EVERY worksheet in the workbook in question. ... The Visual Basic for Applications window will open with an open ... (microsoft.public.excel.misc)
RE: How do break the link from my excel workbook to a access datab ... This one is safer because you get to look at each query as ... The following is for 'QueryTables' or queries embedded in the worksheet: ... Do this on EVERY worksheet in the workbook in question. ... The Visual Basic for Applications window will open with an open ... (microsoft.public.excel.misc)
RE: How do break the link from my excel workbook to a access datab ... This one is safer because you get to look at each query as ... The following is for 'QueryTables' or queries embedded in the worksheet: ... Do this on EVERY worksheet in the workbook in question. ... The Visual Basic for Applications window will open with an open ... (microsoft.public.excel.misc)
Re: Sheets missing ... First thing I'd do is check to see if the workbook is actually opened. ... On the worksheet menu bar, click on Window.... > Excel all the sheets in the workbook are missing, ... (microsoft.public.excel)
Re: How to open Excel workbook in full size window ...Sub Auto_Open ...Application.WindowState = xlMaximized 'maximize the application window ... ActiveWindow.WindowState = xlMaximized 'maximize the workbook window...Excel "remembers" that last window size it was on. ... (microsoft.public.excel.misc)
