Hi All
I have struck a situation that hasn't happened before.
I have a Macro running to Lock all Sheets in my workbook, (16 sheets in
total).
The Macro works fine except for screen updating.
I have put Screen Updating=False at the beginning of the macro &
Screen Updating = True at the end, but no matter what I try it still updates
the screens on the fly. Whilst this is not a major issue, I am using an old
Laptop and this really slows things down.
The syntax is Ok as it was typed in lower case and accepted by VB.
I have used this hundreds of times in the past with no problems.
Any advice would be appreciated

Regards
Michael
--
Michael Mitchelson