View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default New menu item OnAction can't see macro?

FWIW, since your technique inherently breaks cross-platform apps, it
would be worthless to me and most of my clients.

My comments were directed at what I perceived as the knowledge
level/technique employed by the OP, who wished to use OnAction. There
are, of course, almost always alternatives.

Even if I used your technique, I would probably still use a separate
class module rather than ThisWorkbook - it seems cleaner to me. De
gustibus non disputandum est (as your aversion to standard modules
attests).

In article . com,
"Jamie Collins" wrote:

The implicit suggestion is that non-event code has no place in the
ThisWorkbook code module. I must disagree. I find ThisWorkbook far too
convenient; it would be a waste to restrict myself in this way.