Hi guys,
can anyone help with this problem.
I have this bit of code to zoom when a cell is selected.
But the problem is that is stops any ability to be able to undo actions from that particular sheet.
Heres the code..hopefully its just a bit of tweaking.
Thanks in advance
Neil

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$4" Then
ActiveWindow.Zoom = 120
Else
ActiveWindow.Zoom = 56

End If
End Sub