Excel -Use a keyboard shortcut to run a macro located in a Private Module
I want to run a macro "SubIReallyWant" by using a keyboard shortcut.
I can assign the shortcut programatically
That's also easy.
Changing the module to Option Private Module stops the shortcut :-/
Commenting 'Option Private Module makes the shortcut work again
Sure I could Do something like
'Shortcut "Ctrl +Shift + A"
Option Private Module
Do some stuff
Only this is kinda clumsy!
Looking for an eloquent solution?
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents. The steps to find the Templates folder path are …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data.
Rather than update each graph to point to a different set within a static set of data, t…