Excel - "File Not Found: VBA6.DLL"

Question

I have an Excel 2007 Sheet with Macros. When I click on a button, it immediately pops up an error "File Not Found: VBA6.DLL"

Problem is, I have been using this sheet forever, and never seen this problem before. I did make some very very minor changes to the Macro code.

And, I have 2 other sheets with identical macro code which I made the same changes to. And those two sheets run fine.

Any ideas?

Answer 1

In this order:

• Check your references (Alt+F11, Tools-References) to see if any are marked MISSING and make sure that Visual Basic for Applicatiions is checked.

• Check the directory C:\WINDOWS\system32 for VBA6.dll

• You may need to register VBA6.dll (Start->Run)

  Regsvr32.EXE "C:\WINDOWS\system32\VBA6.dll"