Excel 365 vba - (un)protect sheet slows down macro down a lot : Some employees of our company recently switched from office 2007 to office 365. It turns out that the execution time of VBA macros significantly increases in Excel 365. After analyzing the code it became apparent that this increase in time was exclusively caused by "ActiveSheet.(Un)protect"

To give a concrete example: a macro to insert a new line (including some formatting, inserting formulas, etc) increases in execution time from an average of 0.2889 seconds (Excel 2007) to an average of 1.7322 seconds (Excel 365). This difference (i.e. 1.4436 seconds) was caused by an increase in the execution time from (un)protecting the active sheet by 1.5175 seconds (!), which was offset by a slightly faster execution time of the rest of the code -0.0739 seconds.

Does anyone have the slightest idea as to why this is the case? And is there anything that can be done to resolve this without just omitting the protect-functions?

Thank you in advance!