Prev: Looking forMacro to do this Sheet to Sheet copy &sort
Next: Import External Data
From: lawandgrace on 8 Feb 2010 16:10
The following error msg appears when opening my Excel workbook:

"Cannot find #REF!$B$1, which has been assigned to run each time
[WorkbookName]TabName is opened. Continuing could cause errors. Cancel
opening [WorkbookName]TabName?"

There are no macros for this workbook and I right-clicked on the tab name
and selected View Code and there is no code.

Thanks for your help!
From: Dave O on 8 Feb 2010 16:50
In addition to View Code for aarticular tab, please let us know if you
see code when you View Code for This Workbook (at the bottom of the
list of tabs).

Dave O
Eschew obfuscation
From: Gord Dibben on 8 Feb 2010 17:03
Did you look in Thisworkbook module?


Gord Dibben MS Excel MVP

On Mon, 8 Feb 2010 13:10:02 -0800, lawandgrace
<lawandgrace(a)discussions.microsoft.com> wrote:

>The following error msg appears when opening my Excel workbook:
>
>"Cannot find #REF!$B$1, which has been assigned to run each time
>[WorkbookName]TabName is opened. Continuing could cause errors. Cancel
>opening [WorkbookName]TabName?"
>
>There are no macros for this workbook and I right-clicked on the tab name
>and selected View Code and there is no code.
>
>Thanks for your help!

 | 
Pages: 1
Prev: Looking forMacro to do this Sheet to Sheet copy &sort
Next: Import External Data