View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] matthewgdodds@hotmail.com[_2_] is offline
external usenet poster
 
Posts: 8
Default Sheet Code Module: copying code to

I would like to import a Worksheet_SelectionChange sub into the Sheet
Code Module behind a particular sheet.

I can import it into a separate Class Module, but have been unable to
figure out how to direct it into the Code Module behind the specific
sheet it relates to.

Any suggestions?

There's not a lot of code (23 lines, 143 columns), so I guess I could
string it all together as a CreateEventProc but I couldn't help feeling
I must be missing something going that way

Matthew