Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Document Properties - Last Saved, Author | Excel Discussion (Misc queries) | |||
Can the author lose access to a document protected with RMS? | Excel Discussion (Misc queries) | |||
Open an excel document prio to it last being saved | Excel Discussion (Misc queries) | |||
Why do I get an error Document not Saved in Excel? | Excel Discussion (Misc queries) | |||
How do I recover Excel document printed but not saved | Excel Discussion (Misc queries) |