This little bit of VBA can enter the symbol in the footer:


Sub Macro1()
With ActiveSheet.PageSetup
.LeftFooter = Chr(169)
End With
End Sub
--
Gary's Student


"Excel User" wrote:

How do I insert the Copyright symbol in the footer? Many thanks.