April 2006
Beginner
1114 pages
98h 16m
English
workbook.RemovePersonalInformation [= setting]
True removes personal information, such as author name, from a workbook when it is saved; False retains that information (default). The following code saves the workbook, omitting personal information:
ThisWorkbook.RemovePersonalInformation = True ThisWorkbook.Save
The user receives a security warning if the workbook contains macros, since they may contain personal information that Excel can’t remove.
Read now
Unlock full access