| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create muliple event procedures via VBA
Hello,
I want a VBA procedure to create a Worksheet_change procedure for each sheet in a workbook. I have tried many things, but each time Excel and VBA are shut down. One Works fine: ActiveWorkbook.VBProject.VBComponents(ActiveSheet. CodeName).CodeModule.AddFromFile "C:\code.txt" Muliple does NOT work: For each sheet in activeworkbook.sheets sheet.activate ActiveWorkbook.VBProject.VBComponents(ActiveSheet. CodeName).CodeModule.AddFromFile "C:\code.txt" next Anyone? thank you, Derek |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Event procedures: who is calling? | Excel Programming | |||
| Event procedures for spreadsheet cells ? | Excel Programming | |||
| many similar event procedures | Excel Programming | |||
| Event Procedures in an Add-In | Excel Programming | |||
| learning event procedures | Excel Programming | |||
Threaded Mode
