Cannot find . which has been assigned to run eah time . is closed

M

Michelle

I keep getting the following message when I try to close a file

"Cannot find 'C:\Program Files\Microsoft
Office\Office11\Library\adaytum.xla'!AdaytumSheetClose, 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?
 
J

JLGWhiz

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.
 
M

mmkathan

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 said:
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 said:
I keep getting the following message when I try to close a file

"Cannot find 'C:\Program Files\Microsoft
Office\Office11\Library\adaytum.xla'!AdaytumSheetClose, 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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top