[FONT="]I had an application in 2010 which was working fine. I recently have to migrate my application to 2013.
There was lot of flickering occurred in 2013. So I have used application.screenupdating = false in beginning of my macro and set it back to TRUE during end of my macro.
Though setting of application.screenupdating = false/true is working fine and flickering also stopped.
But other issue which I faced is that some of the unlocked cells in my protected sheet have stop responding. Though they are unlocked still I cannot enter any value. Excel almost freeze for them. No worksheet_change events get called. But to my surprise in same sheet I have some drop-down cells and command buttons and when I clicked or select other values from them. Whole sheet becomes responsive and started responding to macros.
Plus executing a simple line of VBA code from background - debug.print sheetname.range("$A$1").locked. i.e. checking locked property of any cell makes those editable cell again working. i.e. I am again able to edit them
Please suggest what to do?
[/FONT]
[FONT="]
[/FONT]
There was lot of flickering occurred in 2013. So I have used application.screenupdating = false in beginning of my macro and set it back to TRUE during end of my macro.
Though setting of application.screenupdating = false/true is working fine and flickering also stopped.
But other issue which I faced is that some of the unlocked cells in my protected sheet have stop responding. Though they are unlocked still I cannot enter any value. Excel almost freeze for them. No worksheet_change events get called. But to my surprise in same sheet I have some drop-down cells and command buttons and when I clicked or select other values from them. Whole sheet becomes responsive and started responding to macros.
Plus executing a simple line of VBA code from background - debug.print sheetname.range("$A$1").locked. i.e. checking locked property of any cell makes those editable cell again working. i.e. I am again able to edit them
Please suggest what to do?

[/FONT]
[FONT="]
[/FONT]