software

Is there a way I can probihit someone from changing the name of Author that
created a Worksheet?

Thanks for help.
Turnerpla

I don't know if you can prevent the change from being made, but you could
automatically return it to a pre-set value with a Change Event macro, like
Before Close, or Before Save..........include this line of code:

ThisWorkbook.BuiltinDocumentProperties(quot;Authorquot;).V alue = quot;OriginalAuthorNamequot;

Of course replacing the text OriginiaAuthorName with the name of the
Author you choose.....

But remember, if macros are disabled, this won't work.....

Vaya con Dios,
Chuck, CABGx3

quot;Turnerplaquot; wrote:

gt; Is there a way I can probihit someone from changing the name of Author that
gt; created a Worksheet?
gt;
gt; Thanks for help.
gt; Turnerpla

Thank you.

quot;CLRquot; wrote:

gt; I don't know if you can prevent the change from being made, but you could
gt; automatically return it to a pre-set value with a Change Event macro, like
gt; Before Close, or Before Save..........include this line of code:
gt;
gt; ThisWorkbook.BuiltinDocumentProperties(quot;Authorquot;).V alue = quot;OriginalAuthorNamequot;
gt;
gt; Of course replacing the text OriginiaAuthorName with the name of the
gt; Author you choose.....
gt;
gt; But remember, if macros are disabled, this won't work.....
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt;
gt; quot;Turnerplaquot; wrote:
gt;
gt; gt; Is there a way I can probihit someone from changing the name of Author that
gt; gt; created a Worksheet?
gt; gt;
gt; gt; Thanks for help.
gt; gt; Turnerpla