I have a VBA Sub that runs on a change of worksheet within my excel
application.

If I include either

With ActiveWindow
.DisplayGridlines = blnShow
.DisplayHeadings = blnShow
.DisplayHorizontalScrollBar = blnShow
End With

Or

Application.DisplayFormulaBar = blnShow

(where blnShow is a boolean value)
in this function, then I seem to lose the ability to paste information that
I have copied before moving worksheet. I can see the information in the
clipboard history. but I cannot paste it, either into excel or into notepad.
I'm not sure if the clipboard is being cleared, or whether it's just some
link to the clipboard.

Setting other Application properties also cause this behaviour, but not
Application.ScreenUpdating = True

Has anyone seen this behaviour before and/or do they know how to stop it?