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