problem when opening/closing worksheets

[Tracy]

I always get this message when opening/closing this particular worksheet at
work:

Cannot find 'C:\XLAPPS\REPORTING\REPORTING.xlm'!modReporting.Auto_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!

 

[Jim Thomlinson]

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...

 

[Tracy]

No codes there either...

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

I always get this message when opening/closing this particular worksheet at
work:

Cannot find 'C:\XLAPPS\REPORTING\REPORTING.xlm'!modReporting.Auto_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]

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.

I always get this message when opening/closing this particular worksheet at
work:

Cannot find 'C:\XLAPPS\REPORTING\REPORTING.xlm'!modReporting.Auto_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!

 

[Jim Thomlinson]

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

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.

I always get this message when opening/closing this particular worksheet at
work:

Cannot find 'C:\XLAPPS\REPORTING\REPORTING.xlm'!modReporting.Auto_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!