VBA Reference Missing

G

George Lee

After moving from an Excel 2007 computer to an Excel 2003 one, I am missing a
reference (to Excel 12), as I would expect. What I didn't excecpt is that now
I can't even open the code module but get an "Error in loading DLL."
Unchecking the reference doesn't work (same error).

How can I open the module?

How can I remove the reference?
 
N

Nigel

I think you should disable macros when opening the workbook then edit the
code and save it as an xlsm.
 

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

Similar Threads

Excel 2003 VBProject Missing reference 4
Remove a missing reference that is in use? 3
Reference to dll object in VBA 4
Reference Errors with Distribution of excel sheets with macros 1
Office XP VBA can't find reference after saving by Office 2003 1
object library problem 2
VBA Function Reference 5
Missing References 1

Top