problem when opening/closing worksheets

T

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!
 
J

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

Tracy

No codes there either...

Jim Thomlinson said:
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 said:
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!
 
D

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!
 
J

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


Dave Peterson said:
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top