macro issue in workbook

Hi All,

Please suggest how to referesh macro automatic when we open / refresh / change input variable in Work book.

and should be availanble for all work book users..

Regards

Amit