Macro Compile Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I loaded a spreadsheet with many macros on a new Dell laptop with office
basic edition and I am getting the following message when executing macros;

Compile Error
can't find project or library

One of the failures is on the CHR instruction. VBE6.DLL is on the system in
the common folder. It is also failing on instructions that reference sheets
within the workbook such as if ['Main Menu'!Z21] = 0
 
In the VBE select Tools -> References. One of the references will be tagged
"Missing:???"
That will be the culpret...
 

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

Can’t find library 2
Compile error 1
Application.VBE.CommandBars -- Compile error 2
Compile error [Chr(13)] 3
excel macro in '97 does not work in Vista 2
Compile Error: with VBA call to "Format" 9
Strange Compile Error... 1
conso macro 0

Back
Top