The WIn key is not in the list of OnKey events. As such, you won't be able to create a macro using the Application.OnKey command.
Research has shown you might be able to capture the WIN key by using a Windows API ... but that would be highly intensive and always dangerous if you are
not fully aware of the implications getting into the Windows API.
I tried using the Macro Recorder to capture the key strokes of WIN + H but the recorder was unable to see those key presses and did not create a macro.
I think you may have something there. And to think with all the websites, forums, etc I researched ... no one suggested what you have.
I'll be following this thread.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.