Member Avatar for tgifgemini

Good people,
Please can someone show me how I can add a permanent comment to the end (footer) of my spreadsheet. I want this comment to be visible when the spreadsheet is printed.

I know how to add the comment on the spreadsheet that is visible only when you hover the cursor on it. But I want to hard-code it in my module.
Thanks,
tgifgemini

  • 2 Contributors
  • 2 Replies
  • 102 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by tgifgemini
Member Avatar for QVeen72

Hi tgif,

I think u want a Custimized Page Footer. This is how you do it :

ActiveSheet.PageSetup.PrintArea = ""
With ActiveSheet.PageSetup
        .LeftHeader = ""
        .CenterHeader = ""
        .RightHeader = ""
        .LeftFooter = "New Page Footer "
        .CenterFooter = ""
        .RightFooter = ""
    End With

REgards
Veena

Member Avatar for tgifgemini

Hi Veena,
Haven't heard from you in a while. I hope everything is okay with you.
Thanks for your input. objective accomplished.
Have a good day.
tgif.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.