Cannot find source of external workbook links

  • Thread starter Thread starter Nette
  • Start date Start date
N

Nette

When opening a workbook that we save under a new name each month we always
get a message " Cannot find _______________ which has been assigned to run
each time (the current workbook) is opened. Cancel Opening_________?"

I have searched for links under edit and used the find function to search
for cells containing the character [ to find formulas etc per the microsoft
help information but am still getting the error.
How else can i find out where this is in the workbook and remove it?
 
I'd look for a subroutine in a General module that's named Auto_Open.

Then I'd look under the ThisWorkbook module for a subroutine that's named:
Workbook_Open.

You could have a macro in either of these locations that try to run something
helpful.
When opening a workbook that we save under a new name each month we always
get a message " Cannot find _______________ which has been assigned to run
each time (the current workbook) is opened. Cancel Opening_________?"

I have searched for links under edit and used the find function to search
for cells containing the character [ to find formulas etc per the microsoft
help information but am still getting the error.
How else can i find out where this is in the workbook and remove it?
Click to expand...
 
Back
Top