Hyperlinks in drop down list

G

Guest

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

Jim Rech

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list with external hyperlinks 1
Filtered drop down list 2
Drop Down List with Macro/Hyperlinks 4
Drop down list includes hyperlink 1
Drop down list and macros? 1
Drop-Down List 3
Create drop-down list with hyperlinks 1
Hyperlinks & Drop down menu 6

Top