ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   When i open my Excel file this message prompt: (https://www.excelbanter.com/excel-programming/284231-when-i-open-my-excel-file-message-prompt.html)

Gilles Chartier

When i open my Excel file this message prompt:
 
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

Bill Manville

When i open my Excel file this message prompt:
 
Gilles Chartier wrote:
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 ?


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


Gilles Chartier[_2_]

When i open my Excel file this message prompt:
 
Thank Bill it's work !
G i l l e s


All times are GMT +1. The time now is 10:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com