Overwrite Thisworkbook code with Macro

hi,

i have 350 workbooks with all different modules. But also codes in "Thisworkbook" (workbook_open and workbook_beforeClose)

Now I forgot to put in "Application.ScreenUpdating = False" Means everytime people open the excel workbook you everything flickering due to its macro.

I need to update those workbooks by Macro anyway and I want to include that code (Application.ScreenUpdating = False) into all the "Thisworkbook"

Now can I do this? Can I overwrite the entire code or do can I just add that piece of text?

Thanks!

Originally Posted by cytop

See http://www.cpearson.com/excel/vbe.aspx

i have seen that site and also Ron de Bruin site and even more, i have googled a lot on this topic. But I don't know how to put this all together.. I guess i need to use vbext_ct_Document
But there isnt any easier way of basically,

Please Login or Register  to view this content.

etc. or insert line.?

This code will add Application.ScreenUpdating = False at the start of Workbook_Open.

Please Login or Register  to view this content.

As it is the code is using ActiveWorkbook, what you need is further code to loop through your workbooks, open them, run this code on them and then saving.

What that code is really depends on if you have a list of the workbooks and their locations, they all reside in the same directory or have a common name - basically something to find them.

Originally Posted by Norie

This code will add Application.ScreenUpdating = False at the start of Workbook_Open.

Please Login or Register  to view this content.

As it is the code is using ActiveWorkbook, what you need is further code to loop through your workbooks, open them, run this code on them and then saving.

What that code is really depends on if you have a list of the workbooks and their locations, they all reside in the same directory or have a common name - basically something to find them.

That is working! Some piece of work this is. I don't understand it fully but indeed I took the code within the loop.. and it placed the code into the thisworkbook!
Although its 1 line above the Workbook_Open. It should go in the the Workbook_open..

Please Login or Register  to view this content.

If that's what's happening then the code isn't working.

I tested it on workbooks that only had code for the Open event.

perhaps use

Please Login or Register  to view this content.

rather than

Please Login or Register  to view this content.

perhaps just

Please Login or Register  to view this content.

you're welcome :-)

don't forget to mark the thread solved