Archive of Mr Excel Message Board

Back to Hyperlinks in Excel archive index
Back to archive home

Hyperlink closes original spreadsheet without saving

Posted by Chris on December 03, 2001 2:21 PM

Hi all,

sometimes when I add a hyperlink, when I click on it, it opens the required location but automatically closes the original spreadsheet without any prompt of save yes/no

Has anyone else seen this problem ? Or know what I'm doing wrong ?

thanks
Chris
:-)

Re: Hyperlink closes original spreadsheet without saving

Posted by JC on December 03, 2001 4:15 PM

That bothered me for the longest time too. In the 1st open .xls file, if a field changes (say just inserting anything anywhere, then your working within the .xls file and click on a hyperlink, your 1st open .xls file will stay open. It's when there has been no change in the original .xls file that it will close it.

Not the proper fix but a simple way around it that I found to help but just simply entering like "x" in any blank field to keep my main .xls list open so that I can ALT TAB back & forth

Re: Hyperlink closes original spreadsheet without saving

Posted by Chris on December 05, 2001 5:56 AM

Ahhhh, yes, that would make sense now !

thanks for the tip JC

:-)

Re: Hyperlink closes original spreadsheet without saving

Posted by Steve W on June 2, 2005

Here are 3 lines of code that should eliminate that problem. I know this is simple, but it took me a while to figure out a solution. Hopefully it can save someone else some time.

Sub Auto_Open()
ThisWorkbook.Sheets(1).Range("z1").Value = Now()
End Sub

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.