Show Document Properties

[Cindee]

Is there a simple formula I can put in a sheet that will
show the Modified date and Last Saved By properites?
This seems to be a simple question but I can't find any
info on it? Must I use VBA? If so, I need a pretty easy
to understand explanation....please.

Thanks in advance,

Cindee

 

[Frank Kabel]

Hi
you'll need VBA. Have a look at
http://www.cpearson.com/excel/docprop.htm
for some explanations
also if you're new to VBA take a look at
http://www.mvps.org/dmcritchie/excel/getstarted.htm