Way to change or update the macro
 

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!

Way to change or update the macro
 

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 he

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.



Christian.Xu wrote:

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