View Full Version : Solved: Freeze Name In Author Field
Wolfgang
08-24-2006, 12:49 AM
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
08-24-2006, 08:35 AM
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
08-24-2006, 09:27 AM
You could put it back in everytime the workbook is saved.
Nice lateral thinking :)
Wolfgang
08-24-2006, 09:43 AM
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
08-24-2006, 01:31 PM
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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.