View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Hyperlinks in drop down list

Excel hyperlinks have to go in cells, as far as I know. If you want to use
a dropdown you'll have to involve macros. See the attached simple example
of one way to do this.

--
Jim
"Jan" wrote in message
...
| Hey. I'm trying to make hyperlinks (i my case to different weeks - 52) in
the
| same sheet. Of course I can write from 1 to 52 and make a hyperlink to
each
| of them, but this will take a lot of space and are'nt pretty either. Is it
| possible to make them in a drop down list, or another way?
|
| Jan (from Norway)