Code runs slow in the new excel (Office 365)

[trimmjens]

My company just converted to the new office 365.
I noticed that some of the VBA codes in my workbooks are executing very slow compared to the previous version

I'm wondering why this is and is it a way around it?
Are there new features in the new version that may affect VBA code execution?

Appreciate all replies

 

[mole999]

what cause the sheets to unlock, if i read this correctly your applying protection to all sheets, maybe detecting those that aren't protected and just do those

 

[trimmjens]

what cause the sheets to unlock, if i read this correctly your applying protection to all sheets, maybe detecting those that aren't protected and just do those

I have another code that unlocks all 14 sheets. The workbook is built so that either all sheets are locked (user mode)
or all sheets are unlocked (administrator mode).