The only other way I could think of achieving this is to shell t
command (wscript) and have it run an outside vbscript for you whic
presses the buttons for you using a timer and sendkeys (obviously cod
halts inside excel while a dialog box is showing). So it would look
bit like this:


sub speculative()

set wsObj = createobject("wscript.shell")
wsObj.run("c:\winnt\system32\cmd.exe /c wscript c:\press_buttons.vbs")
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True

end sub

Then in the vbscript:

sub pressButtons()

set bpObj = createobject("wscript.shell")
bpObj.appactivate("My_Workbook_Name")
bpObj.sendkeys "My_button_presses_here"

end sub

Pure speculation, none of this tested!

Cheers
Jo

--
LFCFa
-----------------------------------------------------------------------
LFCFan's Profile: http://www.excelforum.com/member.php...fo&userid=3748
View this thread: http://www.excelforum.com/showthread.php?threadid=57211