Error on opening Excel workbook

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!
 
D

Dave O

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top