View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Hyperlink target

=HYPERLINK("file:///C:\Documents and
Settings\User\Desktop\Book2.xls#Sheet2!B9")

any book - any sheet - any cell
--
Gary''s Student - gsnu200732


"jacque" wrote:

Can I customer HYPERLINK(formulae) to specify the target location of the url?
target="_parent" is added by default.

thanks,
jacque