cells locking after running macros

[peektheoffense]

hi

recently upgraded all our computers to 2013, rewrote some of the older programs (2003)which wouldn't convert, the custom menubar etc. I am having a problem that after every time in run any of the macros that i cant enter any text into the cells on the sheet (in full screen mode). The dropdowns still work.

it was a big jump from 2003 to 2013, but it all worked quite happily

i have written some code which works, but its a bit messy as in reduces down then back up again. Is there a better solution please. All the macros unprotect the sheet before running then reprotect it after.

i have tried forcing a fullrebuild, but that didn't work. Any clues for a less messy solution. Thanks


Sub resetbits()


Application.WindowState = xlMaximum

Application.ScreenUpdating = False
Application.DisplayFullScreen = False

Application.DisplayFormulaBar = True



Application.DisplayFullScreen = True
Application.ScreenUpdating = True


End Sub

 

[mole999]

With Application
        .DisplayFormulaBar = True
        .DisplayFullScreen = True
        .ScreenUpdating = True
        .EnableEvents = True
    End With

 

[peektheoffense]

thanks will give it a go, again excel is a means to an end.