How do I remove author from saved excel document
I have Office 2000 and want to remove author and other hidden info when I
save documents in Excel. How can I do this? |
How do I remove author from saved excel document
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... "Bill" wrote: I have Office 2000 and want to remove author and other hidden info when I save documents in Excel. How can I do this? |
How do I remove author from saved excel document
There is no security tab option in Excel 2000
"Sheeloo" wrote: 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... "Bill" wrote: I have Office 2000 and want to remove author and other hidden info when I save documents in Excel. How can I do this? |
How do I remove author from saved excel document
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 On Tue, 7 Oct 2008 15:35:01 -0700, Bill wrote: I have Office 2000 and want to remove author and other hidden info when I save documents in Excel. How can I do this? |
All times are GMT +1. The time now is 09:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com