Change vba code in multiple spreadsheets
I have about 50 spreadsheets that I need to change the vba code on.
Basically, there is 1 macro in module1 that needs to be removed from all. Is there an easy way to do this without having to open each, find the macro, and delete? |
Change vba code in multiple spreadsheets
Check out this link...
http://www.cpearson.com/excel/vbe.htm -- HTH... Jim Thomlinson " wrote: I have about 50 spreadsheets that I need to change the vba code on. Basically, there is 1 macro in module1 that needs to be removed from all. Is there an easy way to do this without having to open each, find the macro, and delete? |
All times are GMT +1. The time now is 08:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com