XL97 asks if I want to save, when I click on a web hyperlink.

[Marvin Hlavac]

Please help me with XL97.
---------------------------

When I click on a web hyperlink XL97 gives me this:

"It is recommended that you save the current workbook before continuing. Do
you want to save changes to 'Book1' ?" YES / NO / CANCEL

Is there a way to avoid getting this message? I don't wish to save.

The same workbook in XL-XP will not display the message.

 

[Nick Hodge]

Marvin

I can't test this but does this only happen when the workbook has never been
saved before? (I note your reference to the default name Book1). If so,
make one save and all should be OK.

There is certainly no setting to reverse this and I suspect it was changed
in later versions as XL97 was MS's first real attempt at integrating the web
with applications.

If you were accessing this by code, you may be able to stop it with

Application.DisplayAlerts=False

But as you mention 'when I click' I suspect this is not the case

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Marvin Hlavac]

I can't test this but does this only happen

when the workbook has never been
saved before?

Hi Nick,

Thanks, you are right. I didn't realize it because the workbook *is* saved,
but it is saved as an .xlt template file. In XL-XP it works as intended,
however XL97 is where I have problem. I need the file to be .xlt and I don't
want to be asked if I want to save changes.

If you were accessing this by code,
you may be able to stop it with

Application.DisplayAlerts=False

But as you mention 'when I click' I suspect this is not the case

Code or a regular hyperlink give same result and
"Application.DisplayAlerts=False" is not helping in this case. If I save it
in .xls file all is okay, however I do need it as a template.

Is there a solution to my problem (other then upgrading XL)?

 

[Marvin Hlavac]

Nick, I just want to add that I don't want users to ever save changes and
the template contains:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Saved = True
End Sub

That works when closing the workbook but it doesn't work in the instance
that I described earlier.