Hi
simply a design decision. Functions used in cells ONLY
return values. To achive something like opening files
Microsoft provided worksheet_events

One can argue if this is a good spreadsheet dsign to open
another file depending on a cell value but that really
depends on your requirements. No technical problem with
this

-----Original Message-----
OK, that's clear. Thank you!
Yet I'm still curious why I can put this code in a
worksheet event, and
after checking if target = "=AZ([integer])" performing
actions that are
not allowed in a worksheetfunction.
I mean: is there a serious reason why I shouldn't use a
worksheetevent
for opening other files?


---
Message posted from http://www.ExcelForum.com/

.