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)

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)

Thank you jim, but i miss your attachment ...

Jim Rech skrev:

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

The attachment is right there, at least if you use Outlook Express. Send me
an email if you want it sent directly to you.

--
Jim
"Jan" wrote in message
...
| Thank you jim, but i miss your attachment ...
|
| Jim Rech skrev:
|
| 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
|