Automatically add worksheet change event code

**kl_clifford** · 08-12-2015, 07:20 PM

Hi!
How do i go about having the following code automatically inserted into my worksheet? I've written a macro to format a spreadsheet and I want to highlight any changes that are made to cells by a user after the report is distributed. I don't want it to activate the change event until the very end of the macro though (sorry, i'm a newbie) or else it will highlight all the formatting changes. I need to run this on 100+ reports and don't want to have to insert the worksheet_change to every single one!

Please Login or Register  to view this content.

**natefarm** · 08-13-2015, 03:28 PM

I haven't tried it, but found this article that may help. You may want to add code to open the workbooks from a list, or maybe all files in a folder. Then add the code and save and close. Remember to save as xlsm (if not already) and change the output filetype to xlOpenXMLWorkbookMacroEnabled.

http://stackoverflow.com/questions/1...ook-to-another