No problem. I just figured, New topic, new post. I'm not sure I follow what
you mean regarding "avoiding VBA." I only have a rededial understanding of
this program. Never had a use for Excel in the past. Now trying to create a
"complex" arrangement of directories to manage sales and listings for various
states. I have zero experience creating my own formulas let alone
understanding the language of macros. If you have some really good links to
basic processes which are relevant to Excell 2007 that'd be great. What I
keep finding, though, is tutorials which are based on earlier versions of
excel, which in turn makes it more difficult since a lot of the directories
and functions are not where they used to be. Also, anything that I find for
2007 tends to be "what's new." Lol..I need a "what's old... and where is it
on 2007." Thanks again for your help.
-Kent
"Gord Dibben" wrote:
Kent
Try to stay in the thread you started earlier to maintain some continuity.
How are you creating the dropdown list of sheet links?
Through Data Validation?
You must be trying to stay away from VBA.
You could make this project much easier.
See Debra Dalgleish's site for creating a worksheet navigation Toolbar.
http://www.contextures.on.ca/xlToolbar01.html
I don't think you can create a dropdown list with hyperlinks unless you do
resort to VBA.
Gord Dibben MS Excel MVP
On Sat, 19 May 2007 20:44:01 -0700, Kent K
wrote:
My situation... I want to create a drop down list wherin the entries are
hyperlinked to their respective worksheets. ex: WS=worksheet
WS "Regional Directory" contains a cell where I want to create a drop-down
list.
"Deep South" specifically. I have created a list of all states that reside
in this region.
WS "Drop Down Lists". on this ws I hyperlinked the individual states to
their named worksheets. ie. "Alabama" hyperlinked to "WS Alabama". Named
this list "DeepSouth"
When I create the drop down on WS Regional Directory, using source
"=DeepSouth" It creates a non hyperlinked list which in text matches the
sourced list. However, the list entries within drop-down menu are not
hyperlinked. Which is what I need them to be.
Suggestions??