PDA

View Full Version : put code into the on_open event of 250 workbooks



Joe Heym
03-09-2006, 03:58 AM
I need to add the same 4 lines of code into the on open event of 250 different workbooks. Short of copy and paste this in to each one is there a quicker way? I would like a method that the user of each workbook can trigger to add these lines in.
Any thoughts would be much appreciated

Norie
03-09-2006, 08:26 AM
Check this http://www.cpearson.com/excel/vbe.htm..

Joe Heym
03-09-2006, 08:41 AM
Thanks this has really helped me