You are searching about All Excel Formulas With Examples In Excel Sheet Download, today we will share with you article about All Excel Formulas With Examples In Excel Sheet Download was compiled and edited by our team from many sources on the internet. Hope this article on the topic All Excel Formulas With Examples In Excel Sheet Download is useful to you.

Excel Macro Tips – How To Remove Personal Information From Excel Using Some Simple VBA

In every Microsoft Excel workbook, by default some personal information will be stored inside it, which will be hidden in the workbook itself or in document properties (this is known as meta data). The different types of information that are stored can be the following:

  • your name

  • Your beginnings

  • Your company or organization name

  • Your computer name

  • The name of the network server or hard drive where you saved the workbook

  • Additional file properties and summary information

  • Invisible parts of embedded OLE objects

  • Document versions

  • Text or hidden cells

  • Personal views

  • Comments

If you plan to share your workbook with others electronically then it’s probably a good idea to remove personal information from it. I always remove my personal information from my workbooks especially when making my Excel templates and samples available for public download. Here’s a quick and easy way to write an Excel macro to extract this type of information from your Excel workbook. It’s really easy, and once you get used to it, it can easily become part of your normal routine. to save Excel workbooks.

  • Open the Excel workbook from which you want to delete personal information

  • Press ALT+F11 as a shortcut to open the Developer Tab or you can 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

Now you can easily run the code by selecting below

  • Click the Developer tab

  • Select Macros

  • Select Remove_Information (this is the name we gave the macro in the first line of code.

  • Click OK

  • The next time your workbook is opened, your personal information will be gone.

Additionally, you can run the code in the immediate window which is really useful, as it can be used as a kind of sandbox to test the results of your macros live and see the results. If you need to enable the Instant Window if it doesn’t appear, then press ALT+F11, then press CTRL + G to open the Immediate Window and place the cursor in it.

All you have to do is type the name of the macro in the window where the verb is displayed. In this example we will write Remove_Information then press return and the macro runs.

Video about All Excel Formulas With Examples In Excel Sheet Download

You can see more content about All Excel Formulas With Examples In Excel Sheet Download on our youtube channel: Click Here

Question about All Excel Formulas With Examples In Excel Sheet Download

If you have any questions about All Excel Formulas With Examples In Excel Sheet Download, please let us know, all your questions or suggestions will help us improve in the following articles!

The article All Excel Formulas With Examples In Excel Sheet Download was compiled by me and my team from many sources. If you find the article All Excel Formulas With Examples In Excel Sheet Download helpful to you, please support the team Like or Share!

Rate Articles All Excel Formulas With Examples In Excel Sheet Download

Rate: 4-5 stars
Ratings: 2395
Views: 81676025

Search keywords All Excel Formulas With Examples In Excel Sheet Download

All Excel Formulas With Examples In Excel Sheet Download
way All Excel Formulas With Examples In Excel Sheet Download
tutorial All Excel Formulas With Examples In Excel Sheet Download
All Excel Formulas With Examples In Excel Sheet Download free
#Excel #Macro #Tips #Remove #Personal #Information #Excel #Simple #VBA

Source: https://ezinearticles.com/?Excel-Macro-Tips—How-To-Remove-Personal-Information-From-Excel-Using-Some-Simple-VBA&id=9527838

Có thể bạn quan tâm: