Way to change or update the macro

[Guest]

Used Excel2003 to build a tool which will have interaction with the server,
but will have regular update to the macro which is build in the workbook.
Is there anyway I can update the macro in that wookbook only without
changing the excel formatting etc..?

Thanks!

 

[Dave Peterson]

Depending on the security setting that each user has chosen (and it's the user's
security setting--not something you can change), you may be able to use Chip
Pearson's notes here:

http://cpearson.com/excel/vbe.htm

If it's not too late, you may want to move as much code from the individual
workbooks and create an addin--separating the VBA code from the data as much as
you can.

Then if the macros have to change, you update the addin and redistribute that.