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)
|