Change User Name with VBA

August 15th, 2004 | Categories: Excel.mod | Tags:
-->

You can change the default username with vba. This is the default name that shows in “macro recorded by”, new comments, “last saved by” etc..

1. Put the following code somewhere in your macro

Application.UserName = "MonkeyCoder"
Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
  1. January 30th, 2011 at 14:41
    Reply | Quote | #1

    I enjoy what you guys tend to be up too. This kind of clever work and coverage! Keep up the amazing works guys I’ve you guys to my personal blogroll.