Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a Hyperlink with Data Valadation
In my Budget program, I have the first sheet as my Main Menu, and use
hyperlinks to navigate to other sheets and workbooks. What I did was type the name that I wanted to display and hit Ctrl K. When the dialog box appears, choose "Bookmark" and then the sheet that you want to link to. You can even choose what cell you want Excel to go to. If you want to link to another workbook, follow the above, find the workbook you want to link to. If you don't care what sheet you open the other workbook to, simply hit the "Ok", but let's say you want the hyperlink not only open the other workbook, but load a specific sheet, simply choose that workbook's "Bookmark." A couple of things though. 1. You may get the "Hyperlinks can be dangerous" warning. If you only click on hyperlinks that you or someone else you trust did, you can fix it so Excel doesn't keep popping up this box. 2. The blasted "Web Toolbar" pops up each time you click on a link that loads another worksheet. Don't know why and I've read about creating a macro to stop this. I don't like macros and don't want to lower my security level for a macro. So, what I did was removed all icons from the Web Toolbar and moved it to an out of the way location. Should it pop up, it won't interfere with what I'm doing. Hope this helps. "Scott@CW" wrote: How do I hyperlink a name on a data valadtaion list. I want to the user to choose a name off of a list then whatever name they choose jumps them to the appropiate worksheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Matching Button for MS Excel 2007 or later | Excel Worksheet Functions | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
How to maintain hyperlink when sorting data? | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions |