Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Oh Wise Ones,
I am using Jim Cones XL Extras add-in which does a wonderful job of indexing all the worksheets of a workbook and creates a table of contents with hyperlinks. What I would like is to be able execute the index routine when a new sheet is added either automatically (1st choice) or with a button (2nd Choice). I need the HR rep to be able to do this the easiest possible way. She will be periodically adding sheets, so the index will occasionally need updating. The table index is not available to be added to a custom menu nor is it in a macro that I can access. The only option I see as an vba rookie is to have a sendkeys macro that calls alt,right arrow 4X(to the insert menu) then down arrow 5X. What can I do? Thanks, Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
if function with extras. | Excel Worksheet Functions | |||
Sendkeys alternative to help with XL Extras - Jim Cone | Excel Programming | |||
Spacebar extras removal | Excel Worksheet Functions | |||
Jim Cone | Excel Programming | |||
Alternative to SendKeys | Excel Programming |