Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot find . which has been assigned to run eah time . is closed
I keep getting the following message when I try to close a file
"Cannot find 'C:\Program Files\Microsoft Office\Office11\Library\adaytum.xla'!AdaytumSheetC lose, which has been assigned to run each time [filename] is closed. Continuing could cause errors. Cancel closing [filename]? I never set up any kind of file to run when closing? I did originally receive this file from someone else. How can I remove this so I don't get this message everytime I close the file? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot find . which has been assigned to run eah time . is closed
Open your VB editor, Alt + F11, and right click on ThisWorkbook in the upper
left small window. Select View Code from the drop down menu and look for a code procedure that begins with Private Sub Workbook_BeforeColse(). See if that code contains the refenced files in the error message. If it does, make sure it does not affect the rest of the workbook if it is deleted and then delete it. Before you delete it, copy it to Notepad so that if your file does not operate properly after you delete it, you can put it back in. "Michelle" wrote in message ... I keep getting the following message when I try to close a file "Cannot find 'C:\Program Files\Microsoft Office\Office11\Library\adaytum.xla'!AdaytumSheetC lose, which has been assigned to run each time [filename] is closed. Continuing could cause errors. Cancel closing [filename]? I never set up any kind of file to run when closing? I did originally receive this file from someone else. How can I remove this so I don't get this message everytime I close the file? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot find . which has been assigned to run eah time . is clo
Thanks for your response. When I open VB editor and look for the code
procedure Private Sub Workbook_BeforeColse(), it's not there. The "Private Sub Workbook_BeforeColse()" is there, but the () are blank, there is no reference to the mentioned file. "JLGWhiz" wrote: Open your VB editor, Alt + F11, and right click on ThisWorkbook in the upper left small window. Select View Code from the drop down menu and look for a code procedure that begins with Private Sub Workbook_BeforeColse(). See if that code contains the refenced files in the error message. If it does, make sure it does not affect the rest of the workbook if it is deleted and then delete it. Before you delete it, copy it to Notepad so that if your file does not operate properly after you delete it, you can put it back in. "Michelle" wrote in message ... I keep getting the following message when I try to close a file "Cannot find 'C:\Program Files\Microsoft Office\Office11\Library\adaytum.xla'!AdaytumSheetC lose, which has been assigned to run each time [filename] is closed. Continuing could cause errors. Cancel closing [filename]? I never set up any kind of file to run when closing? I did originally receive this file from someone else. How can I remove this so I don't get this message everytime I close the file? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot find . which has been assigned to run each time . is close | Excel Discussion (Misc queries) | |||
verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
Find values in a closed excel workbook. | Excel Programming | |||
find in closed workbook | Excel Programming |