![]() ![]() Press Alt + Q to close the Editor window and switch back to your workbook.Choose " Excel macro-enabled workbook" from the " Save as type" drop-down list and click the Save button. ![]() Press Crl + S, then click the " No" button in the " The following features cannot be saved in macro-free workbook" warning dialog. Save your workbook as " Excel macro-enabled workbook".As a result, the performance is increased from 10% to 500% (aha, the macro works 5 times faster if it continuously manipulates the cells' contents). These lines, as their names suggest, turn off screen refresh and recalculating the workbook's formulas before running the macro.Īfter the code is executed, everything is turned back on. ![]()
0 Comments
Leave a Reply. |