Macro

[Shelly]

Everytime a particular document is opened I get the following error message:

Cannot find "file name and path\[test.xlm]test'!A$1, which has been assigned to run each time the document is opened.

The file name and path no longer exists, where can I go to delete this so it will stop coming up when the document is opened. I checked to see if there was a Macro and I couldn't find one. I am using Excel version 2002.

 

[Gord Dibben]

Shelly

Sounds like code in the Workbook Module.

With the file opened, right-click on the Excel Icon at top left of the menu
bar(next to "File").

Select "View Code". Delete what you don't want from there then File>Save.

Gord Dibben Excel MVP

 

[Gord Dibben]

Shelly

Your subject and description pointed to an auto run macro, but that might not
be the problem.

How about links to another workbook?

Do you see anything under Edit>Links?

How about a named range? Insert>Name>Define. Anything there?

Download Bill Manville's FINDLINK.XLA from Stephen Bullen's site.

http://www.bmsltd.ie/MVP/Default.htm

With this add-in you can find and delete links if any exist.

Gord

I checked the code and I couldn't find anything that I could recognize. I was looking for something that said test.xlm. Was I looking for the wrong thing? Could the document be corrupted?

Shelly

Sounds like code in the Workbook Module.

With the file opened, right-click on the Excel Icon at top left of the menu
bar(next to "File").

Select "View Code". Delete what you don't want from there then File>Save.

Gord Dibben Excel MVP

Everytime a particular document is opened I get the following error message:

Cannot find "file name and path\[test.xlm]test'!A$1, which has been assigned to run each time the document is opened.

The file name and path no longer exists, where can I go to delete this so it will stop coming up when the document is opened. I checked to see if there was a Macro and I couldn't find one. I am using Excel version 2002.

 

[Gord Dibben]

Ooooops!

Just noticed the test."XLM" which is an Excel 4.0 macro.

I am not familiar with these so my input should stop here.

Apologies, Gord

I checked the code and I couldn't find anything that I could recognize. I was looking for something that said test.xlm. Was I looking for the wrong thing? Could the document be corrupted?

Shelly

Sounds like code in the Workbook Module.

With the file opened, right-click on the Excel Icon at top left of the menu
bar(next to "File").

Select "View Code". Delete what you don't want from there then File>Save.

Gord Dibben Excel MVP

Everytime a particular document is opened I get the following error message:

Cannot find "file name and path\[test.xlm]test'!A$1, which has been assigned to run each time the document is opened.

The file name and path no longer exists, where can I go to delete this so it will stop coming up when the document is opened. I checked to see if there was a Macro and I couldn't find one. I am using Excel version 2002.

 

[Shelly]

You did help, I found the macro in insert/name/define. Thanks so much!

Ooooops!

Just noticed the test."XLM" which is an Excel 4.0 macro.

I am not familiar with these so my input should stop here.

Apologies, Gord

I checked the code and I couldn't find anything that I could recognize. I was looking for something that said test.xlm. Was I looking for the wrong thing? Could the document be corrupted?

Shelly

Sounds like code in the Workbook Module.

With the file opened, right-click on the Excel Icon at top left of the menu
bar(next to "File").

Select "View Code". Delete what you don't want from there then File>Save.

Gord Dibben Excel MVP

Everytime a particular document is opened I get the following error message:

Cannot find "file name and path\[test.xlm]test'!A$1, which has been assigned to run each time the document is opened.

The file name and path no longer exists, where can I go to delete this so it will stop coming up when the document is opened. I checked to see if there was a Macro and I couldn't find one. I am using Excel version 2002.

 

[Gord Dibben]

Shelly

That file path you found in Insert>Name>Define was a reference to the Excel
4.0 Macro Sheet.

Glad you found it and are fixed up.

Gord

You did help, I found the macro in insert/name/define. Thanks so much!

Ooooops!

Just noticed the test."XLM" which is an Excel 4.0 macro.

I am not familiar with these so my input should stop here.

Apologies, Gord

I checked the code and I couldn't find anything that I could recognize. I was looking for something that said test.xlm. Was I looking for the wrong thing? Could the document be corrupted?

:

Shelly

Sounds like code in the Workbook Module.

With the file opened, right-click on the Excel Icon at top left of the menu
bar(next to "File").

Select "View Code". Delete what you don't want from there then File>Save.

Gord Dibben Excel MVP

Everytime a particular document is opened I get the following error message:

Cannot find "file name and path\[test.xlm]test'!A$1, which has been assigned to run each time the document is opened.

The file name and path no longer exists, where can I go to delete this so it will stop coming up when the document is opened. I checked to see if there was a Macro and I couldn't find one. I am using Excel version 2002.