Change VBA using VBA??

[cmhoz]

I have a group of users who all have a set of files on their computers... but we've found a bug in one of the macros.

I'm sending them an 'update' file that will update a bunch of other things in their files - is there a way to also change the macro that is broken??

eg: I need to add to 'sub insertincentive' the line: Application.Goto Reference:="incentives"

Thanks!

 

[pgc01]

Hi

Chip Pearson explains how to do it here:

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

I'm assuming the projects are not protected.