Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
When i open my Excel file this message prompt:
Thank Bill it's work !
G i l l e s |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove Prompt to Open File as Read-Only (Excel 2007) | Excel Discussion (Misc queries) | |||
Excel 2007 prompt to open file as read only | Excel Discussion (Misc queries) | |||
Prompt message when opening a file | Excel Worksheet Functions | |||
Prompt Message when opening a file | Excel Worksheet Functions | |||
Bypass prompt to open XML file as XML list? | Excel Discussion (Misc queries) |