LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Updating Worksheet Event Code Module via VBA

I have a large number of workbooks where I need to perform VBA code
maintenance.

I am updating all the code in the workbooks by first deleting all existing
code (modules, forms, worksheet code modules) and then import in the updated
modules / forms to to each work work.

I have one worksheet in each workbook ("Census") where I need to replace the
existing Worksheet_Change event code.

I already have the logic / process to remove all code from the workbooks and
import the updated modules / forms and worksheet code module.

Where I am stumped is how to import or add a updated Worksheet_Change event
code moulde.

Is there a way in VBA where I can import or enter the updated
worksheet_change event logic for the "Census" worksheet code module?

Any help would be greating appreciated!!!

Patrick

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Run Event Code In General Module Who I Am Excel Programming 2 April 26th 06 07:26 PM
Where?Worksheet code module or Worksheet_SelectionChange event han Kenzie Excel Worksheet Functions 4 January 30th 06 09:41 PM
Run worksheet module code from workbook module? keithb Excel Programming 1 August 14th 05 04:04 AM
Updating form labels from code in a module news.verizon.net[_2_] Excel Programming 2 October 29th 03 04:03 AM


All times are GMT +1. The time now is 08:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"