How do I remove author from saved excel document

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I have Office 2000 and want to remove author and other hidden info when I
save documents in Excel. How can I do this?
 
I am not sure about Excel 2000 but in Excel 2003 do the following;

On the Tools menu, click Options, and click the Security tab.
Select the Remove personal information from file properties on save check
box.
Save the document.

User name can be updated on General tab.

Excel 2000 should have similar options...
 
There is no security tab option in Excel 2000

Sheeloo said:
I am not sure about Excel 2000 but in Excel 2003 do the following;

On the Tools menu, click Options, and click the Security tab.
Select the Remove personal information from file properties on save check
box.
Save the document.

User name can be updated on General tab.

Excel 2000 should have similar options...
Click to expand...
 
Bill

This gets rid of a few builtins and any Custom properties.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _
Cancel As Boolean)
With ThisWorkbook
.BuiltinDocumentProperties("Author").Value = ""
.BuiltinDocumentProperties("Company").Value = ""
.BuiltinDocumentProperties("Title").Value = ""
.BuiltinDocumentProperties("Subject").Value = ""
.BuiltinDocumentProperties("Manager").Value = ""
For Each p In .CustomDocumentProperties
p.Value = ""
Next
End With
End Sub

Which other properties would you like to remove?


Gord Dibben MS Excel MVP
 
Back
Top