List box not being displayed in second worksheet

[Guest]

I have created a workbook with two worksheets.

The first sheet has a drop down list box (created from the control toolbox)
and a command button. This drop down list will be used to select a custom
view for the second sheet based on the selection in the list. The sheet also
contains a text box with a title.

I have a second sheet that contains a large table and on the top part of the
sheet I have freezed the panes and have included another drop down list box
and command button.

When I make a selection in the first worksheet to open up a custom view of
the second sheet, the second sheet is opened with the custom view, but the
drop down list box is not visible and actually contains the part of the image
from the first sheet (ie. the title text). I have to actually click on the
drop down list several times to make it appear.

Any suggestions as to why this is happening?

Thanks

Brian

 

[Guest]

Thanks Dave,

I've managed to get around the problem by selecting a blank sheet and then
selecting the sheet I actually need.

Probably not the best solution, but it works and the user will not supsect a
thing

Brian