View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frederick Chow Frederick Chow is offline
external usenet poster
 
Posts: 75
Default Dynamically create procedures in a sheet module

Hi all,

Does anybody here know how to dynamically create procedures in a sheet
module without using the troublesome InsertLines or CreateEventProc methods?
If the procedures are located in a standard module then I can always use a
CopyModule approach thus bypassing those troublesome methods, but can I do
the same with sheet modules? Thanks for your advice in advance.

Frederick Chow
Hong Kong.