Solved: Freeze Name In Author Field

[Wolfgang]

Good Morning All...

Is it possible to "freeze" the name in the Author: - field of the file properties menu, so that it can't be changed using Windows Explorer right-click Advanced Options?!

Thank you...

Best,
Wolfgang

[Desert Piranha]

Good Morning All...

Is it possible to "freeze" the name in the Author: - field of the file properties menu, so that it can't be changed using Windows Explorer right-click Advanced Options?!

Thank you...

Best,
WolfgangH Wolfgang,

You could put it back in everytime the workbook is saved.


Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
ThisWorkbook.BuiltinDocumentProperties("Author").Value = "Your Name Here"
End Sub

[Bob Phillips]

You could put it back in everytime the workbook is saved.

Nice lateral thinking :)

[Wolfgang]

Hi Dave...

that'll do...

It's like a game until someone finds out about its rules...

Thank you very much and have a nice day in the USA...

Best,
Wolfgang

[Desert Piranha]

Hi Dave...

that'll do...

It's like a game until someone finds out about its rules...

Thank you very much and have a nice day in the USA...

Best,
WolfgangHi Wolfgang,

Glad it helped, you could also password protect your VBE,
and you also have a nice day in Germany.

xld, Thx for the kind word.