79196440

Date: 2024-11-17 03:27:51
Score: 2.5
Natty:
Report link

You can set a shortcut key combination in the properties of your flow (Alt+S) for example, then in Excel Developer tab insert a button and assign a macro to it. In the code use the SendKeys function to simulate the keystroke. You do need to find available combinations that Excel hasnt already consumed which can be somewhat annoying since almost every function in Excel seems to have a shortcut. But its possible and works really well.

Reasons:
  • No code block (0.5):
  • Unregistered user (0.5):
  • Single line (0.5):
  • Low reputation (1):
Posted by: Peter McDowell