Brett,
I added a msgbox to the workbook open event of a workbook.
I opened the workbook using a hyperlink formula and insert hyperlink.
(by clicking them from a worksheet cell)
The msgbox was displayed no matter which link was clicked.
--
Jim Cone
Portland, Oregon USA
(MS dumped about 400 newsgroup messages, this morning,
into my Outlook Express - dated 02/27/2009 and on)



"Brettjg"
wrote in message
I have a worbook that has an OPEN event to make the window size half the
available width. If I open a file from a cell via =hyperlink the workbook
window is always full width. Adding a worksheet activate event to resize the
window fixes the problem, but..........there are too many workbooks to go
through and a an activate event.

Is there something I could do with a followhyperlink event in the workbook
that I'm calling from? This particular workbook (TOOLS) has hyperlinks to my
entire life, so I don't really want to add activate events to everything.

Furthermore, even though I have folder options set to open folders in the
SAME window, whenevr I open a folder from TOOLS via a hyperlink, it comes up
in a separate and very annoying window (particularly if I've drilled down 2
or 3 levels). Regards Brett. (Yes Jim, I'm still at it)