View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default 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?