Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem when opening/closing worksheets
I always get this message when opening/closing this particular worksheet at
work: Cannot find 'C:\XLAPPS\REPORTING\REPORTING.xlm'!modReporting.A uto_Close, which has been assigned to run each time [Financial Statements.xls]xlsMacroData is closed. Continuing could cause errors. Cancel closing [Financial Statements.xls]xlsMacroData? I just click on "NO" button and the worksheet works fine. I looked "Tools - Macro" and there are no macros listed. It is annoying to see this message every time. So would like to know how to get rid of it. I am using Excel 2003. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem when opening/closing worksheets
Code can hide in a number of different places. Right click on the XL icon in
the upper left hand corner of the Excel window beside the File menu option. Select View Code. This takes you into the ThisWorkbook code module where I suspect the offending code might be... -- HTH... Jim Thomlinson "Tracy" wrote: I always get this message when opening/closing this particular worksheet at work: Cannot find 'C:\XLAPPS\REPORTING\REPORTING.xlm'!modReporting.A uto_Close, which has been assigned to run each time [Financial Statements.xls]xlsMacroData is closed. Continuing could cause errors. Cancel closing [Financial Statements.xls]xlsMacroData? I just click on "NO" button and the worksheet works fine. I looked "Tools - Macro" and there are no macros listed. It is annoying to see this message every time. So would like to know how to get rid of it. I am using Excel 2003. Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem when opening/closing worksheets
No codes there either...
"Jim Thomlinson" wrote: Code can hide in a number of different places. Right click on the XL icon in the upper left hand corner of the Excel window beside the File menu option. Select View Code. This takes you into the ThisWorkbook code module where I suspect the offending code might be... -- HTH... Jim Thomlinson "Tracy" wrote: I always get this message when opening/closing this particular worksheet at work: Cannot find 'C:\XLAPPS\REPORTING\REPORTING.xlm'!modReporting.A uto_Close, which has been assigned to run each time [Financial Statements.xls]xlsMacroData is closed. Continuing could cause errors. Cancel closing [Financial Statements.xls]xlsMacroData? I just click on "NO" button and the worksheet works fine. I looked "Tools - Macro" and there are no macros listed. It is annoying to see this message every time. So would like to know how to get rid of it. I am using Excel 2003. Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem when opening/closing worksheets
The .xlm files are the old macro workbooks (pre xl95, but still work in later
versions (not sure about xl2007).) If you're using xl2003 menus, try: Format|Sheet|Unhide It sounds like you may have an old macro sheet that calls this external macro. Tracy wrote: I always get this message when opening/closing this particular worksheet at work: Cannot find 'C:\XLAPPS\REPORTING\REPORTING.xlm'!modReporting.A uto_Close, which has been assigned to run each time [Financial Statements.xls]xlsMacroData is closed. Continuing could cause errors. Cancel closing [Financial Statements.xls]xlsMacroData? I just click on "NO" button and the worksheet works fine. I looked "Tools - Macro" and there are no macros listed. It is annoying to see this message every time. So would like to know how to get rid of it. I am using Excel 2003. Thanks! -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem when opening/closing worksheets
XL4 macro sheets can get hidden in ways that are not necessarily easy to find
IIRC. Here is some code that will unhide them if they exist... Public Sub UnHideExcel4Worksheet() Dim wks As Object For Each wks In Application.Excel4MacroSheets wks.Visible = xlSheetVisible Next wks Set wks = Nothing End Sub Paste this code anywhere the workbook and run it... -- HTH... Jim Thomlinson "Dave Peterson" wrote: The .xlm files are the old macro workbooks (pre xl95, but still work in later versions (not sure about xl2007).) If you're using xl2003 menus, try: Format|Sheet|Unhide It sounds like you may have an old macro sheet that calls this external macro. Tracy wrote: I always get this message when opening/closing this particular worksheet at work: Cannot find 'C:\XLAPPS\REPORTING\REPORTING.xlm'!modReporting.A uto_Close, which has been assigned to run each time [Financial Statements.xls]xlsMacroData is closed. Continuing could cause errors. Cancel closing [Financial Statements.xls]xlsMacroData? I just click on "NO" button and the worksheet works fine. I looked "Tools - Macro" and there are no macros listed. It is annoying to see this message every time. So would like to know how to get rid of it. I am using Excel 2003. Thanks! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OPENING AND CLOSING OF EXCEL 07 FILES | Excel Discussion (Misc queries) | |||
Opening then later Closing an Excel file in VBA | Excel Discussion (Misc queries) | |||
Slow Opening & Odd Closing | New Users to Excel | |||
Closing a workbook upon opening another | New Users to Excel | |||
Error while opening/Closing excel | Excel Discussion (Misc queries) |