Forum Discussion

yedawo7592's avatar
yedawo7592
Copper Contributor
Sep 26, 2021

How to disable "Document Properties and Personal Information" / "Author" save by default

By default, excel adds personal information to the workbook, which I know how to remove after I've created and saved the workbook via: "File -> Info -> Check for Issues -> Inspect Document -> Inspec...
excel
office 365
yedawo7592's avatar
yedawo7592
Copper Contributor
Sep 27, 2021

NikolinoDE The macro option (the third option in your reply) is the closest that I've seen yet. I guess that if I would manage to make it run whenever a new workbook is created it would be almost what I wanted. By the way the registry option (the second option in your reply) don't seem to have any effect in my machine. Thanks you for the help.

yedawo7592's avatar
yedawo7592
Copper Contributor
Sep 27, 2021

I've ended up using the VB from above to make it execute whenever a new workbook is created and remove personal information. These are the steps in case anyone else needs it:


1) Create a "personal.xlsm" file and put it in "C:\Users\<USER>\AppData\Roaming\Microsoft\Excel\XLSTART\"

 

2) In the Macro Dialog in the "personal.xlsm" file then:

 

a) Add a new class called "AppEvents"

 

b) In the "AppEvents" dialog enter the following code:

Private WithEvents App1 As Application

Private Sub Class_Initialize()
  Set App1 = Application
End Sub

Private Sub App1_NewWorkbook(ByVal Wb As Workbook)
  RemovePersonalInformation
End Sub

Private Sub RemovePersonalInformation()
  Application.DisplayAlerts = False

  With ActiveWorkbook
    .RemovePersonalInformation = True
    .Save
  End With

  Application.DisplayAlerts = True
End Sub

c) In the "ThisWorkbook" dialog enter the following code:

Private AppEvents1 As AppEvents

Private Sub Workbook_Open()
  Set AppEvents1 = New AppEvents
End Sub

 

Resources