Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-12-2017, 10:14 AM
grantworth grantworth is offline Macro to change user name Windows 8 Macro to change user name Office 2010 32bit
Novice
Macro to change user name
 
Join Date: Apr 2015
Posts: 5
grantworth is on a distinguished road
Default Macro to change user name

Trying to set up a macro that will change my user name in MS Word tracking but I keep getting debug and VB "break" code messages. Any suggestions? If I could just create a macro for part of it, that would be helpful.
Thanks.
Reply With Quote
  #2  
Old 01-12-2017, 01:32 PM
macropod's Avatar
macropod macropod is offline Macro to change user name Windows 7 64bit Macro to change user name Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Did you look at the entry for the Application.UserName Property in the VBA help file? It's usage is pretty simple. Beyond that, there's not much advice that can be given without seeing your code.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 01-13-2017, 05:24 AM
grantworth grantworth is offline Macro to change user name Windows 8 Macro to change user name Office 2010 32bit
Novice
Macro to change user name
 
Join Date: Apr 2015
Posts: 5
grantworth is on a distinguished road
Default

Thanks for your response. I'm not up on VB unfortunately. Here's the macro I wrote.....It doesn't excecute at all, though other macros are working. I have a "pause" button on the keyboard. Can I use that?

Sub trackingname()
'
' trackingname Macro
'
'
Application.UserName = "EL"
Application.UserInitials = "EL"
Application.UserName = ""
Application.UserInitials = ""
Application.UserAddress = ""
End Sub
Reply With Quote
  #4  
Old 01-13-2017, 02:21 PM
macropod's Avatar
macropod macropod is offline Macro to change user name Windows 7 64bit Macro to change user name Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Did you run the macro, then go to File|Options and check whether the username is now 'EL'?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
macro, tracking, user name

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Computer User Name Change Affects iPad ottiliegirl Office 0 03-24-2015 11:41 AM
Macro to change user name Pausing a Macro for User Selection and continuing anirudhsood Word VBA 1 09-04-2012 08:34 PM
Macro to change user name Change standard highlight text color to user defined Scott Duffens Word 2 06-18-2012 03:53 PM
Macro to change user name Best way to offer macro user options? Jennifer Murphy Word VBA 1 02-15-2012 09:44 PM
Change User Settings Globally within an Office. Welshie82 Word 0 10-24-2011 07:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:23 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft