View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
GS GS is offline
external usenet poster
 
Posts: 364
Default E-Signature by username

Hi maximus73,

Application.UserName

is a read/write property that contains what's been entered in the "User
name:" box on the ToolsOptions...General tab (last item).

It might be more practical to just have your users "Insert" their own
signatures because to do this how you want requires modifying your code to
include each user's .UserName. (..just a suggestion!)

Eric's code is constructed properly and will work as long as you replace his
"example usernames" with "actual usernames" for each 'Case Is' line. Include
lines for each user.

HTH
Regards,
GS