View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Nik[_4_] Nik[_4_] is offline
external usenet poster
 
Posts: 3
Default Execute class method on all worksheets?

I'm not sure if this is what you want. You probably need to set up a
collection to hold the instances of your class -- this needs to be set up in
a module -- not a class module. See the following:


Aah, thanks. That was what I was looking for. Too bad events have to
be enabled for it to work so
there is some flickering but at least it works.