Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Prohibiting the change of Author Name on Worksheets
Is there a way I can probihit someone from changing the name of Author that
created a Worksheet? Thanks for help. Turnerpla |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Prohibiting the change of Author Name on Worksheets
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("Author").V alue = "OriginalAuthorName" 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 "Turnerpla" wrote: Is there a way I can probihit someone from changing the name of Author that created a Worksheet? Thanks for help. Turnerpla |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Prohibiting the change of Author Name on Worksheets
Thank you.
"CLR" wrote: 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("Author").V alue = "OriginalAuthorName" 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 "Turnerpla" wrote: Is there a way I can probihit someone from changing the name of Author that created a Worksheet? Thanks for help. Turnerpla |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
Deselecting Worksheets | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Why do my dates change when I copy them between Excel worksheets? | Excel Worksheet Functions | |||
Protect/unprotect all worksheets | Excel Worksheet Functions |