Error on opening Excel workbook

  • Thread starter Thread starter lawandgrace
  • Start date Start date
L

lawandgrace

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!
 
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
 
Back
Top