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
|