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

Re: VB 6.0 - How to programatically add a comment to spreadsheet 80 80

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

Re: VB 6.0 - How to programatically add a comment to spreadsheet 80 80

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 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.