Question
3
Replies
77
Views
Flextronics
Posted: December 20, 2017
Last activity: December 28, 2017
Closed
Disable Formulas in Excel Sheet
Hello guys
We have a case where we need to copy sheets from one workbook to another using macros but we have formulas in the worksheets and its taking a lot of time to copy. When we manually run the macro we can disable the formulas and enable it after copying .But through automation is there a way to do the same?
You'd have to edit the macro itself to copy without formulas.