Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Remove personal information in Excel document

Status
Not open for further replies.

jslmvl

Vendor
Jan 26, 2008
268
GB
Hi,

I know we can remove personal information from Excel 2007 document by Prepare - Inspect Document. However, it wont work when the document includes macros.

My question would be: When my Excel2007 document includes macros, how can I remove personal information from it?
 
Guess that it works in the same way as in xp-2003: a warning appears when workbooks contains macros or activex controls. Excel does not examine information in those components (for instance comments added to recorded macro). However, standard personal information is removed.

combo
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top