ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2003: Freeze Panes with list boxes (https://www.excelbanter.com/excel-programming/396290-excel-2003-freeze-panes-list-boxes.html)

[email protected]

Excel 2003: Freeze Panes with list boxes
 
Hi All,

I have an excel sheet, a pretty huge one, that queries ANALYSIS CUBES
(database) to get the data onto its sheet. I have a sheet where a
particular set of columns are frozen in the left. Since the sheet
which is a report has data for months, I'll have to scroll to the
right of the sheet.


When I do so, a set of list boxes that are placed on the frozen area
are moved from their original location. The more I scroll to the
right, the more it moves to the left and disappears and the list box
loses its functionality.


I am using EXcel 2003, heard about a similar byg in Excel '97. Can
anyone help me out with this problem?

Many Thanks,
Haarish.



All times are GMT +1. The time now is 10:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com