Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
External Links in Excel 2007 with variable source file | Excel Worksheet Functions | |||
Find External Links | Excel Discussion (Misc queries) | |||
Find External Links | Excel Worksheet Functions | |||
Links to External Workbook | Excel Worksheet Functions | |||
Find cells with external links | Links and Linking in Excel |