LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Brian
 
Posts: n/a
Default List box not being displayed in second worksheet

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
List on different worksheet bevpike Excel Discussion (Misc queries) 3 January 25th 05 10:39 PM
How to open a workbook with a specific worksheet displayed by defa ThaiNB New Users to Excel 2 January 21st 05 06:11 AM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM
How do I create a validation list on a separate worksheet? Ronaldo Excel Worksheet Functions 2 November 26th 04 10:23 PM
Validation - List - Separate Worksheet J. Osborne Excel Worksheet Functions 1 October 28th 04 04:23 PM


All times are GMT +1. The time now is 08:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"