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?

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?

Thank you for your response. However, when I go into VB editor and delete

Private Sub Workbook_BeforeClose(Cancel As Boolean)

End Sub

Then save and close I get the same error message when closing. Also when I
go back into VB editor

Private Sub Workbook_BeforeClose(Cancel As Boolean)

End Sub

is still there?


"Charles Stover" wrote:

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?