Hi all,
I have a huge worksheet full of sumproduct formulas which fatches links
from various other files and creats summary reports.I do not want to
reveal formulas I have used which will be used against me (directly or
indirectly). Manually creating VBA code for the same for more then 300
formulas is quite tedius.

Is there a way by which I can capture the status of the whole sheet
(all formulas and links) in VBA which can be used later to creat the
sheet again when required?

Regards,
Madiya