View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
BEEJAY BEEJAY is offline
external usenet poster
 
Posts: 247
Default Compile Error: Expected Variable or Procedure, Not Project

QCNum_Updater is a macro in Module 1, that calls other subs and messages from
Modules 2 and 3.
All my modules are set up with "Option Explicit". I've read that it is a
good thing to do.
Yes, when I right click on QCNum_Updater, I get taken directly to the
procedure in Module # 1.



"Jim Thomlinson" wrote:

What exactly is QCNum_Updater. I am assuming it is a procedure of some sort?
I assume that it exists somewhere in your project. If you right click on it
and select Definition it takes you to the procedure? Do your modules include
"option explicit" at the top?
--
HTH...

Jim Thomlinson


"BEEJAY" wrote:

Have used / tested the following numerous times over the past few months.
Not that I'm almost ready to send out my "package", I tried one last test.
The first time it worked great. The 2nd time, I get the compile error
message, as shown above.
I copied over the "master/back-up" and tried again, with the same error
result.
Can someone direct me as to what is happening, and how I can correct this?

Private Sub Workbook_Open()
QCNum_Updater
End Sub