in the vb editor, double click thisworkbook in the project explorer, paste this
in the code window and enter the name you want to show:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
ThisWorkbook.BuiltinDocumentProperties("Author").V alue ="Your Name"
End Sub

--


Gary Keramidas
Excel 2003


"Lise" wrote in message
...
Thanks Gary - but where do I enter that sentence please??
--
Thanks

Lise


"Gary Keramidas" wrote:

not sure if it can be locked or not, but maybe you can set it in the workbook
before save procedure

ThisWorkbook.BuiltinDocumentProperties("Author").V alue ="Your Name"


--


Gary Keramidas
Excel 2003


"Lise" wrote in message
...
Hi there

Is there a way to lock the author details found in properties? I don't want
other users to be able to change this but at the same time don't want to
have
to password protect the whole sheet.

Any help as always appreciated
--
Thanks

Lise

.