Mike,
Thanks for the kind comments. However, I don't understand the new problem.
The add-in creates a menu item on the Insert menu called "Table of Contents".
Why not just install the add-in on the HR reps computer?
When the menu item is clicked it adds the TOC or, if one already exists, asks
the user if they want to replace the existing one.
The program can also be activated by the keyboard with Alt + I, T and Y (if necessary).
You could use send keys to do the same - but why?
Regards,
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Mike K"
wrote in message
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