View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Option Private Module not preventing cross project referencing

I thought it worked that way, too.

But some minor testing in xl2003 showed that "application.run" didn't care about
public or private subs. (Referencing projects and using Call did have trouble.)

I'm not sure if this is a change in the way xl2003 works or if it's my (and
yours!) bad memory.

Are you using xl2003?

If no, then it must be a memory failure <bg.

seisman wrote:

I have a procedure in a project module declared as a "Sub
ToggleGridlines()" that is being called by someone elses Add-in. I
have placed "Option Private Module" at the top of the module but the
Add-in is still calling it. Am I missing someting here. This has
always prevented this happening in the past!
Seisman


--

Dave Peterson