Excel Sendkeys Question RRS feed

  • Question

  • How can I determine the number or letter assigned to a toolbar button in Excel, using VBA?
    I am trying to go to Add-Ins, then Custom Toolbars, then click "Log Off", to log off of SAP. On my computer, it's simply: Application.Sendkeys ("xy36"). However, the "y36" part seems to be different from time to time, and when different users use it on their computer. If I could determine what the code (i.e. "y36") were going to be each time, I could hit it right everytime.
    Thoughts, help or suggestions would be very appreciated! Thank you!
    Wednesday, September 21, 2011 3:59 PM