Enable drill down in workbook using Macros

We have used macros extensively in reports for some calculations. How can I enable drilldown for these workbooks without affecting the Macros used for calculations. Macro calculations are currently hardcoded to specific cells.

Any ideas?

Thanks