If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Error when closing file
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
Error when closing 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? |
Thread Tools | |
Display Modes | |
|
|