Copy VBA from Workbook_Open() into multiple others in a directory

[shenty]

Hi

Is it possible to copy all the VBA code from one 'ThisWorkbook' Workbook_Open() sub into multiple other xlsx files in a directory.

i have a sub that runs on Workbook_Open() of a master quote xlsx file that i have fine tuned since working from home recently. It opens a background xlsx file & updates the links (location of the background price xlsx file) if necessary.
Now i have it pretty much how i want it i want to be able to copy all this code & paste into the corresponding Workbook_Open() of multiple xlsx files in a directory.

Thanks in advance for any help.

[Pepe Le Mokko]

Administrative note

Still using XL2003 as indicated in your profile?
If not,perhaps update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to? Members tailor answers based on your Excel version.
Thanks

[shenty]

sorted - thanks for that.

[LJMetzger]

Hi shenty,

Workbook_Open() of multiple xlsx

.xlsx files are not allowed to have Macros. If you have .xlsm files or want to save .xlsx files as .xlsm it can be done, but it is not trivial.

Chip Pearson had graciously shared VBE secrets with us at before his untimely passing. http://www.cpearson.com/excel/vbe.aspx

To get started, you have to follow the instructions at the top of the URL explicitly, or you will get compile and/or runtime errors.

Good luck.

Lewis