Hi,
I am currently writing some VBA script for excel, due to time constraint, I have to release the early version of utility to the users, all together there are more than 6 copies of them distributed out.

Question,
1) For every change of new revision, I have to copy the latest macro to the users workbook manually, it is not a present experience of manual updating. Is there a way to automatically delete the old macro module then add the latest module onto the workbook without overwriting the data on the workbook.

I have tried using the macro recorder to extra the code out..but no code is generated.


2) How to enforce user select macro running option while excel startup. If user do not select macro running, is there a way to detect it.


thanks alot
regards
kaileong