Remove Personal Information Examples

By | 2019-11-18

Remove-Personal-Information-Examples-300x185 Remove Personal Information Examples


Remove Personal Information Examples

By default, every Microsoft Excel workbook stores some personal information that is hidden in the workbook itself or in the document’s properties (known as metadata). The different types of stored information may include:

Your name
Your initials
Name of your company or organization
The name of your computer
The name of the network server or disk on which you saved the workbook
Other file properties and summary information
Invisible parts of embedded OLE objects
document revisions
Hidden text or cells
Personalized views

If you plan to share your workbook electronically with other people, it’s probably a good idea to remove personal information from it. I always remove my personal information from my workbooks, especially when I provide my Excel templates and examples for public download. Use the following simple method to quickly and easily create an Excel macro to remove this type of information from your Excel workbook. Once you get used to it, you can easily become part of your normal routine of saving your Excel workbooks.

Open your Excel workbook from which you want to remove your personal information
Press ALT + F11 as the keyboard shortcut to open the Developer tab, or alternatively select the Developer tab – Visual Basic
Click Insert Module
Enter the following code in the module

Sub Remove_Information ()

ActiveWorkbook.RemovePersonalInformation = True

End Sub

You can now simply run the code by selecting the following

Click the Developer tab
Choose macros
Select Remove_Information (this is the name given to the macro in the first line of code.
Click OK
The next time you open your workbook, your personal information will be lost.

Alternatively, you can run the code in the immediate window, which is very useful as it can be used as a kind of sandbox to test the results of your macros live and display the results. If you need to enable the Immediate window when it is not visible, press ALT + F11 and then CTRL + G to open the Immediate window and place the cursor inside it.

All you have to do is enter the name of the macro in the window in which the cursor flashes. In this example, we would type Remove_Information and then press Return, and the macro will be executed.

Leave a Reply

Your email address will not be published. Required fields are marked *