Excel 97 hyperlinks

[Phil]

According to the knowledge base article 156264, the
function of hiding workbooks when navigating by hyperlinks
in Excel 97 is actually a program anomaly. I use Excel as
a database for 800 customers and navigate to each workbook
via an index of hyperlinks. The fact that the
hyperlink "closes" clean documents and leaves dirty
one "open" is of great use as I just use "control-tab" to
see what sheets i have actually changed the pricing or
information on and print them as necessary, then save the
changes. SInce I talk to many of these customers each day
I do not want lots of workbooks open on the screen and
this "bug" is a lifesaver in this respect.

I now have Excel 2000 and find that each workbook that is
navigated to via hyperlink stays open and this is a
nightmare. Is there a way in which I can force the books
to "close" or "Hide" when navigating through them by
hyperlinks?

Any ideas would be greatly appreciated

 

[BrianB]

Yes, but you might then need to unhide them <grin>.
This code goes into the ThisWorkBook code module and will hide the
current sheet when you select another.

'------------------------------------------------------------
Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
Sh.Visible = False
End Sub