Excel sheet hides when hyperlinking to Word

[Steve Crombie]

Hi all.

I'm new to this group so I hope this hasnt been posted recently, apologies
if it has

The problem I have is that I have created hyperlinks from my Excel 97
spreadsheet which opens documents created in MS Word 97. The link works
fine and the Word document is displayed but when I go back to Excel to
select a different link the workbook is hidden. Once I have unhidden the
workbook I can open other documents in word through the hyperlink but the
workbook remains unhidden!

Incidently, if I close the first Word document opened by a hyperlink, then
go back to Excel, the workbook has actually closed!

Has anyone ever encountered these problems before? Does anyone know a way
to get round these problems?

Thanks in advance.

Best regards,

Steve Crombie

steve....@virgin.net

[Steve Crombie]

I have got the solution for this (from someone on another chat forum), but
if anyone knows of a better way....

if you make a "change" to the sheet before you hyperlink
to something else, the first sheet stays open. Follow procedure outlined
below

Get into any sheet in the workbook you are hyperlinking FROM.
Click on the tools pull down;
select macros;
click on "record new macro"
Make sure that the box "store macro in" has "this workbook" option in it.
save it with the name of AUTO_OPEN (type as shown!!!)

record the following macro(you must have the "formatting" tool bar at the
top of the sheet):
position yourself within a blank cell
Click "underline" on in the formatting tool bar
Click "underline" off in the formatting tool bar (so the net result is
nothing has changed).
Stop recording the macro by pressing the stop button on the "stop
recording" toolbar.

Because you used the macro name AUTO_OPEN, this macro will be executed each
time you open the sheet, and the sheet will not close when you hyperlink to
something else.

Regards,

Steve.

Steve Crombie wrote in message ...