Erin

In my experience, you can't do this other than with the FollowHyperlink
event.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Erin" wrote in message
...
I am creating a hyper-link on each cell using the
hyperlinks.add method
I want this hyper-link to open in a new window, but don't
see a property for this?

The only place I can see to force it to open in a new
window is with doing a hyperlinks.follow, but I have to
code this as an event on the spreadsheet. I would rather
have the hyperlink already on the spreadsheet that Excel
handles the user interface.