View & Activate Workbook with Shortcut Key

TangentialAccel

New Member
Joined
Jan 22, 2018
Messages
7
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

Well-known Member
Joined
Jun 27, 2011
Messages
1,945
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

New Member
Joined
Jan 22, 2018
Messages
7
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.
 

Forum statistics

Threads
1,082,269
Messages
5,364,150
Members
400,783
Latest member
sambills

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top