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? |
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? |
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? |
All times are GMT +1. The time now is 04:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com