| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
Al
Are the sheets hidden? If they are hidden, you will need VBA to unhide and select the applicable sheet. If the sheets are not hidden, try this: Right-click within the sheet navigation arrows located in the left lower corner of the screen. This will display a list of the sheets in the workbook. Click on one and it will become the active sheet. If the displayed list does not include all the sheets, the last item in the list will be "More sheets". Click on that and you will get a scrollable list of all the sheets. Post back if you need more. HTH Otto "Al" <(E-Mail Removed)> wrote in message news  0BA4555-6C93-4F13-B194-(E-Mail Removed)...>I have an excel (2003) document which has quite a number of sheets. I would > like to create a form (msg box) which lists all the sheet names (via a > drop > down box) for the user to select which sheet they want to view, then open > the > sheet when they click on the sheet name. Help please? |
|
|
|
|
|||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to create a Static drop down List in a Form | Meg M | Microsoft Outlook Form Programming | 2 | 27th Nov 2007 02:59 PM |
| create drop down list error message in a form | =?Utf-8?B?U2hlcnJ5IE1ja2lubGV5?= | Microsoft Access | 0 | 14th Jun 2007 01:30 PM |
| how do I create drop-down list on an existing form | =?Utf-8?B?bmFubmll?= | Microsoft Access | 1 | 22nd Nov 2006 10:01 PM |
| How do I create a drop down list in a form using Word? | =?Utf-8?B?RG9ubmE=?= | Microsoft Word New Users | 3 | 21st Jun 2005 04:37 PM |
| Create drop list on form from range names? | Ed | Microsoft Excel Programming | 2 | 15th Feb 2005 03:56 PM |
