Can we insert Custom Properties in the header in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Aryan - 19 Jan 2007 04:48 GMT

Hello All,

I have been struggling through a problem from long time. Can we insert
Custom Properties in the header in Excel. If yes, how??? Is it possible

only through macros & not without that?? Can anybody get me the macro
code.

My main problem is, I want to insert the date through a field/Custom
Property in the Header so that user can easily go and change the date
just by updating the field as we do in MS WORD.

Plz somebody help. Its urgent.

Thanks,
Rudra

Reply to this Message

Bob Phillips - 19 Jan 2007 09:38 GMT

Yes, it needs code

Private Sub Workbook_BeforePrint(Cancel As Boolean)
With ActiveSheet.PageSetup
.LeftHeader = ActiveWorkbook.CustomDocumentProperties("myDate")
End With
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Hello All,
>
[quoted text clipped - 12 lines]
> Thanks,
> Rudra

Reply to this Message

Aryan - 19 Jan 2007 10:11 GMT

Hey.......thnk u very much Bob......dat code really worked.......thnx
very much once again

Reply to this Message