Thanks for your concern.

basically I have some reports those auto_open  macro.

by this macro  I need to copy some calculation result in another column before
the calculation.

because this report run on daily basis and i need to hold pervious %age for
references.

when I publish this reports to concern than I need to delete  this macro before
publishing.

this is reason for deleting the macro.