View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pallaver pallaver is offline
external usenet poster
 
Posts: 62
Default Compiler Error - Not an Appropriate Name

I've got what I believe to be an organization problem in my Excel
macros (using 97-2003 version).

Here's the situation:

In Option Explicit Module1 I have a program which calls a bunch of sub
routines from Module3 which is an Option Private Module.

This works fine.

Now I'm adding into other variations to the macro on Module1, so I've
made Module4 contain a macro which uses one of the sub routines on
Module3 (Option Private Module), only I'm getting the following error:
Compilation Error: Not an appropriate name: TeishutsuItemRow

I have listed TeishutsuItemRow as a public variable on my new macro on
Module4. What code rule am I violating? Is there anyway I can reuse
a sub routine on an Option Private Module sheet in multiple macros
located on multiple modules?

Thanks, NP