+ Reply to Thread
Results 1 to 4 of 4

code to execute a keyboard shortcut or to execute a toolbar button

  1. #1
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    455

    code to execute a keyboard shortcut or to execute a toolbar button

    Hi all,

    Is there an easy way to code a keyboard shortcut or to click a toolbar button?

    Its basically an essbase button to refresh numbers from Oracle.

    The shortcut i usually use is:
    / Y D R R

    Is there an easy was to code this into a button?

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: code to execute a keyboard shortcut or to execute a toolbar button

    Is the data imported in an Excel sheet?

    If yes then you can write a little macro that will refresh that particular data connection and then assign a short key to it..

    Let me know if you need any help

    Hope it helps!
    Cheers!
    Deep Dave

  3. #3
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    455

    Re: code to execute a keyboard shortcut or to execute a toolbar button

    yes the data is being imported from a hyperion cube via refreshing the sheet.

    Is there no way to code the following keyboard keys "/ Y D R R "?

  4. #4
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    455

    Re: code to execute a keyboard shortcut or to execute a toolbar button

    managed to get this bit of code to work but testing on another pc not everyone's excel shortcuts will be the same, is there a possible workaround?

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Execute a macro in a closed workbook, or open and execute without the user noticing
    By cearaujo123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-09-2015, 06:44 PM
  2. How To execute a button (click event) with code?
    By jamiguel77 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2014, 11:22 AM
  3. Replies: 2
    Last Post: 07-13-2013, 01:10 AM
  4. VBA scripts to execute commonly keyboard combination
    By elcaris in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2008, 04:01 PM
  5. Q. Shortcut key to execute an event procedure
    By jno in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-04-2007, 06:47 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1