79338563

Date: 2025-01-08 09:34:28
Score: 4
Natty:
Report link

Sorry, but the code from Black cat did not work to me. I got this: enter image description here

After much trial and error I got this code to work:

Application.PrintCommunication = False
With ActiveSheet.PageSetup
    .LeftHeader = ""
    .CenterHeader = "&L&H&S&V&D&L&H&S"
    .RightHeader = ""
End With
Application.PrintCommunication = True

It gives me enter image description here just as I want. But I can not say I understand how it works. It would be nice to do.

Reasons:
  • Blacklisted phrase (1): did not work
  • RegEx Blacklisted phrase (1): I want
  • Probably link only (1):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: CamillaT