Macro Not Found...

[wotonka]

I have an existing spreadsheet which has a worksheet (called tmplt) with an area used as a template for other worksheets (tabs 1000, 2000). When in tab 1000 for example, a macro opens the tmplt tab, copies the templat area, and pastes it (along w/ formulas) into the 1000 tab. It works fine. The problem is, when I click on the "tmplt" tab, and click anywhere in the area of that sheet, an error appears "The macro 'Schedule.xls'!AddLine' cannot be found". The error message is correct, there is no macro with the referenced title, but why would just clicking within any area of the tab "tmplt" cause a macro (which happens to not exist) to try to execute? I inherited this spreadsheet, so maybe there is an auto-execute function somewhere??

Thanks for any help you may offer. It is most appreciated !

 

[wotonka]

This is making me nuts.
---I have looked in all the macro code within Modules 1,2,3 (the only module), and nothing seems to call "'Schedule.xls'!AddLine".
--- I don't see a Personal. XLS workbook as viewed from the editor.
--- I doo see projects called "funcres (FUNCRES.XLA)" and "atpvbaen.xls", but both are password protected.

Do you have any other suggestions? Thanks very much.

 

[Joe4]

The only thing I can tell you is to check for macros in the individual Sheet modules, and ThisWorkbook module and make sure there is no code there. If there is, see if it selects any other sheets, and check them for code.

Other than that, I am out of ideas.

 

[wotonka]

All of the sheet modules do not have any code in them except...
Sheet 6 has "Option Explicit" Would that have any bearing on this? (Sheet 6 is not used during normal operations).

If that is not relevant, then let me just offer my sincere thanks for your patience and help !!

 

[Joe4]

No, that shouldn't cause a problem. The "Option Explicit" command just requires you to declare all your variables before you use them.

 

[wotonka]

OK, thanks again. The "philosophical treatise" about fishing is a good chuckle. Thanks !

 

[Datsmart]

Try looking in the Named Ranges.

Insert => Name => Define

See if "'Schedule.xls'!AddLine" appears anywhere.

 

[starl]

Wotonka - can you send out the workbook? If so can you email it to me at: Tracy @ this site

 

[wotonka]

Datsmart: Thanks for the suggestion, but after searching, I cannot find any instances of this string using Insert > Name > Define

Tracy, I can't send you the workbook due to company policy. That's like telling someone who has thrown you a life buoy that it can't be made from stryene. I am sorry, and appreciate your offer.

 

[starl]

It would just make things easier.

What happens if you disable macros?
Do you even get a prompt to enable macros when you open the workbook? Anything about 4.0 Macros?
How old is the workbook?

 

[starl]

what happens if you rename tmplt?
zoom out on the sheet - do you see anything in areas you thought weren't used?