Thread: Compile error
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Compile error

Hi Sam

With the workbook open on the problematic pc, try:

Alt-F11 to open the VBE
Tools | References |
Find and uncheck a reference marked "Missing"


---
Regards,
Norman


"sam0344" wrote in message
...
I can open this macro from another computer but everytime I open it up from
my computer...it has a compile error for :

QTextBox = Workbooks(SourceName & ".xls").Sheets("Database").Cells(i, 36)

It says cannt find Project or library...whats wrong?