Properties of workbook
 

I am using EXCEL 97.

Can someone supply me with code that I can customise the properties of the
workbook with, please.


Thanks
--
Mark

Properties of workbook
 

Hi Mark

Look in the VBA help for
BuiltinDocumentProperties

And on Chip's page
http://www.cpearson.com/excel/docprop.htm

With ActiveWorkbook.BuiltinDocumentProperties
..Item("Author") = "RDB"
End With




--
Regards Ron de Bruin
http://www.rondebruin.nl


"Mark" wrote in message ...
I am using EXCEL 97.

Can someone supply me with code that I can customise the properties of the
workbook with, please.


Thanks
--
Mark