Popup index

[David0079]

Hey Guys,

Does anyone have any ideas or workarounds for this little task? I currently have a macro which lists all of the sheet names in the workbook in a given cell and turns them into a hyperlink for that sheet. This is a bit messy though as the sheets come and go quite often. Anyone have any idea how I can get a little popup window to do the same thing??

Many thanks in advance

Dave

 

[jindon]

Sub test()
     CommandBars("workbook tabs").ShowPopup
End Sub