Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
John,
if you are just trying to make a POPUP to make sheet selection easier, have play with this bit of code & see if helps you. Sub SelectSheet() If ActiveWorkbook.Sheets.Count <= 16 Then Application.CommandBars("Workbook Tabs").ShowPopup 500, 225 Else Application.CommandBars("Workbook Tabs").Controls("More Sheets...").Execute End If End Sub -- jb "John" wrote: I'm trying to make a 2 column list box, filled with sheet names. I have 72 sheet tabs in my workbook, and would like to make a simple "go to" out of the 2 column list box, where you click on the sheet name and it selects the sheet. (I'd like half the sheet names on the left, the other half on the right). I appreciate any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Fill rows downwards with column names | Excel Programming | |||
Generate sheet names from list, assign data to summary sheet. | Excel Programming | |||
List image names into col & fill cell comments with corresp images | Excel Programming | |||
Fill cells with names from list | Excel Programming | |||
Need to create a list of sheets from a list of names in column a | Excel Programming |