View Single Post
  #2   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

I tried that. The created macro was empty. Also, if I wanted to attach a
button, wouldn't that require me to put in in a module? Then I would need to
focus on the worksheet "table of contents" before the sendkey events. Sorry
for my vba prowess, but I am a quality technician improving some excel sheets
in my not-so-spare time.

Thanks,
Mike

"Gary''s Student" wrote:

I see....

First trying to turn on the Recorder and then call Cone's stuff from the
menu bar. It may capture the correct syntax for you

You can add more
Application.SendKeys "{DOWN}"
to get you to the proper place, to do the mouse click will require a
differenct API:

http://scriptorium.serve-it.nl/view.php?sid=44


--
Gary''s Student
gsnu200712