View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Charles Stover[_2_] Charles Stover[_2_] is offline
external usenet poster
 
Posts: 7
Default Error when closing file

It sounds like the original person had the file setup to save a particular
way using VB scripting/Macros.

Go to:
TOOLS
MACRO|Visual Basic Editor

In the left side pane, find the name of the workbook. You may need to
expand it.
Under the name of the workbook, highlight "This Workbook" (May need to
double click on it)
In the right hand pane, you will see any macros/VB entries. If there aren't
any macros/VB, then you won't see anything.
May look like this:
Private Sub Workbook_BeforeClose(Cancel As Boolean)

End Sub

Highlight, delete and save the file. Make sure you aren't in need of
anything there. Usually a On C
Close and see what happens.
"mmkathan" wrote:

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?