View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike K Mike K is offline
external usenet poster
 
Posts: 104
Default Sendkeys alternative to help with XL Extras - Jim Cone

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