Troubleshooting Question on Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have a spreadsheet I am attempting to troubleshoot that is producing an
error which I have looked into here. What I have read tells me that there is
normally a procedure identified to facilitate troubleshooting. My error note
does not identify the procedure and I'm at my wits end trying to figure this
out... If someone could please advise me I would greatly appreciate it!!

The error in excel reads
Cannot find <procedure>, which has been assigned to run each time
[<workbook>]<worksheet> is opened. Continuing could cause errors. Cancel
opening [<workbook>]<worksheet>?

In my case, it does not show a procedure to track down... the error note
begins
"Cannot find , which has been assigned to run..."

Just a comma after "Cannot find" , no procedure identified... Any ideas out
there? Thanks!
 
Hi, the procedure must be in a macro. These can be located in Workbook,
worksheet or Module. Press ALT + F11 to see the VB Editor and make sure that
the Project window is visible (Ctrl + R). you should be able to see what
Modules, sheet codes are in attached to the workbook.

Have a look and if the code is not there delete any modules that have no code.

Hope this helps
Regards
Peter
 
Billy, That was my first thought also. However... I have looked through the
VB Editor and viewed each worksheet, module and "ThisWorkbook" in the Project
Window and did find 1 module with no code in it. I deleted the module and
something is still causing this error note... The only existing module does
have user defined macro's in it but nothing I can associate with this
problem. One thing I have found are queries within some of the sheets, could
a query be the culprit here?

--
If you can read this, thank a Teacher...
If your reading it in english, thank a Veteran!


Billy Liddel said:
Hi, the procedure must be in a macro. These can be located in Workbook,
worksheet or Module. Press ALT + F11 to see the VB Editor and make sure that
the Project window is visible (Ctrl + R). you should be able to see what
Modules, sheet codes are in attached to the workbook.

Have a look and if the code is not there delete any modules that have no code.

Hope this helps
Regards
Peter

Telobamipada said:
Hi, I have a spreadsheet I am attempting to troubleshoot that is producing an
error which I have looked into here. What I have read tells me that there is
normally a procedure identified to facilitate troubleshooting. My error note
does not identify the procedure and I'm at my wits end trying to figure this
out... If someone could please advise me I would greatly appreciate it!!

The error in excel reads
Cannot find <procedure>, which has been assigned to run each time
[<workbook>]<worksheet> is opened. Continuing could cause errors. Cancel
opening [<workbook>]<worksheet>?

In my case, it does not show a procedure to track down... the error note
begins
"Cannot find , which has been assigned to run..."

Just a comma after "Cannot find" , no procedure identified... Any ideas out
there? Thanks!
Click to expand...
Click to expand...
 
Back
Top