View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Jamie Collins Jamie Collins is offline
external usenet poster
 
Posts: 593
Default New menu item OnAction can't see macro?


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


Could you expand on that please?

if I used your technique, I would probably still use a separate
class module rather than ThisWorkbook - it seems cleaner to me.


Interesting. I don't see the advantage of using a class module. There
would be no code re-use within the project; you'd only need once
instance. There is unlikely to be reuse between projects. Encapsulation
for its own sake? It seems to me that if something is 'workbook level'
it is more 'logical' to me to have it in the ThisWorkbook module.
Jamie.

--