Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
List on different worksheet | Excel Discussion (Misc queries) | |||
How to open a workbook with a specific worksheet displayed by defa | New Users to Excel | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
How do I create a validation list on a separate worksheet? | Excel Worksheet Functions | |||
Validation - List - Separate Worksheet | Excel Worksheet Functions |