If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I Need a formula to evaluate a cell with + or - values | Bob in Oklahoma | Worksheet Functions | 6 | October 31st, 2005 02:41 PM |
Why do my dates change when I copy them between Excel worksheets? | rrjohnsonia | Worksheet Functions | 6 | June 1st, 2005 09:42 PM |
Sorting problem, sums change | Mychele | General Discussion | 1 | February 5th, 2005 03:45 PM |
Worksheets are referenced in expressions, how make the worksheets visible? Excel 2000 | L Mehl | General Discussion | 2 | July 27th, 2004 07:20 PM |
A change of track changes | Lorrie | Formatting Long Documents | 1 | June 12th, 2004 02:32 AM |