View & Activate Workbook with Shortcut Key

[TangentialAccel]

Hi,

I have workbook that I would like to bring to the foreground and activate when I press an assigned shortcut key (even if the workbook isn't active). The idea is that the workbook could be minimized, hidden behind other windows, or visible, and when the shortcut key is pressed, it will activate the workbook so I can directly edit it.

I have tried assigning a shortcut key within windows to open a workbook but the problem is that it tries to open the file even if the file is already open.

So, I was wondering if this can be done with VB code? I've tried a couple of things, but nothing that works when the workbook is deactivated or minimized.

Thanks in advance...

 

[gallen]

Not as straight forward as you may think unless you are familiar with Macros and PERSONAL.xlsb

You can write a Macro and assign a shortcut to it to do what you ask. However, for the macro to work from ANY open workbook you need to store the macro in PERSONAL.xlsb which is a hidden workbook that opens every time you open Excel.

If you struggle with implementation, come back.

 

[TangentialAccel]

Gallen,

Thank you for your input. The issue I have with this method is that the user has to be in Excel for the shortcut and macro to work...at least as far was I can see.

My goal is for the user to be able to bring the Excel workbook up with the shortcut key even if the user is in another application like Chrome, Word, etc.