When i open my Excel file this message prompt:

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When i open my Excel file call Chartier file this message prompt
Cannot find'\\P$\my doccuments\A.GIL\[COLLHELP.XLM]COLLHELP'!$B$15, which has been assigned to run each time[Chartier file.xls]Épargne is opened. Continuing could cause errors. Cancel opening [Chartier file.xls]Épargne

Then... i have to click YES OR NO and i say NO with out proble

Please help me... to remouve this messege prompt Note: Épargne is the tab name ( tab used last time i save

G i l l e s... THANK in advence
 
Gilles said:
When i open my Excel file call Chartier file this message prompt:
Cannot find'\\P$\my doccuments\A.GIL\[COLLHELP.XLM]COLLHELP'!$B$15,
which has been assigned to run each time[Chartier file.xls]Épargne is opened.
Continuing could cause errors. Cancel opening [Chartier file.xls]Épargne ?
Click to expand...

There's probably a hidden name that refers to this Excel 4 macro.

Try running this

Sub ShowHiddenNames()
Dim N As Name
For Each N In ActiveWorkbook.Names
N.Visible = True
Next
End Sub

and then look in Insert / Name / Define dialog for names referring to such.

Alternatively use FINDLINK from http://www.BMSLtd.co.uk/mvp and look for COLLHELP.XLM

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup
 
Back
Top