views:

552

answers:

1

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?

A: 

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"

Remou