pending link in EXCEL 2000

  • Thread starter Thread starter jérome Yacc
  • Start date Start date
J

jérome Yacc

I'm facing a strange problem:
In a initial workbook, where a lot of cell names are defined, a VBA
application is creating a "printable" sheet from an existing one.
A printable sheet is defined as a sheet with no formula, only values.

I want to copy this sheet in a new workbook (Edition->Copy/move a sheet
/with a copy, towards a new workbook)
Surprisingly, the new workbook shows pending links towards the initial
workbook, althougth there are only values in copied sheet.
But more surprisingly, if I close this new workbook *without* saving
it, and if I re-do a copy in a new workbook, this time the new workbook
does not show anymore pending links towards the initial one.

It seems therefore that the first closing with no saving cleans up
something in the application, so that the second copy behaves as
expected (no links transported)

Is there a way to simulate this "cleaning" process in VBA?

thank you
 
I don't know if it's the right one, but I've found a solution to m
problem :

It turned out that during the execution of the VBA,
"Application.DisplayAlerts = False" was systematically executed, t
prevent user message during a delete operation. But the problem is tha
the DisplayAlerts = True was no set again.

Adding this DisplayAlerts = True instruction seems to solve my pendin
links problem.
A collegue of mine found the problem by constating that the Clos
action was not working properly (the Application was not requesting
workbook save, although a sheet was added).

If anyone has a rational explanation of the correlation o
DisplayAlerts and pending links, I'll take it
 
Back
Top