View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Cannot find source of external workbook links

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.

Nette wrote:

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?


--

Dave Peterson