adding a signature text to a "Signature Line"

I have over 50 excel files to prepare and need to add a visible Signature Line in them and would like to automatically sign them with my name in the signature text box.

I have this code

Please Login or Register  to view this content.

and the bit that doesnt work is >>>>

Please Login or Register  to view this content.

i have also tried >>>>>

Please Login or Register  to view this content.

I cant seem to find out online what the signature text box is called, where in the object it's located (assuming it's not in setup) and how to automatically populate it with text instead of a signature picture image for example. I havent tried "SigLine" which someone suggested online -but still dont know if it has a location before it.

all the other bits seem to work...

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)