Hyperlink to open new window?

  • Thread starter Clueless in Seattle
  • Start date
C

Clueless in Seattle

I've created a simple Excel file that I use as a project menu.

Each cell in the first column contains the name of a project and a
hyperlink to the file containing that project.

This works great for opening non-Excel project files. But when I
click on a cell hyperlinked to an Excel project file, Excel closes my
"Project Menu" file and opens the new project file in the same window
where the project menu had been displayed. This is a bummer because
most of my project files are Excel files.

Then, the next time I need to access my project menu, I have to first
manually reopen the project menu file, before I can use it. And as
soon as I use it again, it gets closed by Excel when it opens the new
file. And round and round I go, all day long.

Is there a command I can put in my hyperlinks that will instruct Excel
to open each new project in a new window?
 
J

Jim May

Just curious, but try going to the menu, tools, options, Under Show - check
on Windows in Task bar; OK out and try again to see if that changes anything
(favorably) for you.
 
C

Clueless in Seattle

Jim May said:
Just curious, but try going to the menu, tools, options, Under Show - check
on Windows in Task bar; OK out and try again to see if that changes anything
(favorably) for you.
Click to expand...

I think you are on the right track, because I found exactly that
solution on the web. Trouble is my antique version of Excel (67)
doesn't seem to have that option on the options tab.

There is a "View" tab, not a "Show" tab, and it has a section at the
bottom labeled "Window options." But I'm unable to find "Windows in
Taskbar" among the options.

Here's what I see:

Page breaks Row & column Horizontal scroll bar
Formulas Outline symbols Vertical scroll bar
Gridlines Zero values Sheet tabs

Do you think my ancient version lacks this feature?
 
J

Jim May

Try going into Excel and in Tools=>Options=>General tab make sure Ignore
Other Applications is not checked.
 
G

Gord Dibben

Yes.

Excel 97 does not have the "Windows in Taskbar" feature.

Excel 2000 was first version with that feature.

Gord Dibben Excel MVP
 
Top