Be aware that that will still require forcing a calculation for the cell to
update.

--
HTH

Bob Phillips

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

"Ardus Petus" wrote in message
...
Try:

Function CustomProperty(sProp As String) As Variant
Application.Volatile
CustomProperty = ActiveWorkbook.CustomDocumentProperties(sProp)
End Function


HTH
--
AP

"KC" .(donotspam) a écrit dans le message de news:
...
Thanks Ardus, it works, but now i have another problem; if i make any
changes
to the file properties the changes are not getting refreshed in the
cells!

thanks,
-KC

"Ardus Petus" wrote:

Paste the Function I sent you into a standard Module.
In your worksheet, enter:
=CustomProperty("blah")

HTH
--
AP

"KC" .(donotspam) a écrit dans le message de news:
...
sorry there was a typo,

Hi There,
Now I know how to create these File/Custom property fields, but I
don't
know
how to make *use of them in the worksheet!
in simple, How to insert the File/custom property fields into excel
cells?

Thanks,
-KC


"KC" wrote:

Hi There,
Now I know how to create these File/Custom property fields, but I
don't
know
how to make you of them in the worksheet!
in simple, How to insert the File/custom property fields into excel
cells?

Thanks,
-KC