ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Application.OnKey problem (https://www.excelbanter.com/excel-programming/303572-application-onkey-problem.html)

R Avery

Application.OnKey problem
 
I have an add-in that has saved in it a list of keys and procedure names
that I would like to be set whenever the add-in is loaded (which is by
default loaded whenever Excel loads). A list looks something like this:

+^b Personal.xls!ToggleBanding
^w Personal.xls!PrependText
+^w Personal.xls!AppendText
%{F9} Shared.xla!CalculateRange

The problem that I am encountering is that this add-in loads before
Personal.xls, and whenever I press CTRL-w, it attempts to load another
copy of my Personal.xls. It's error message is: "A document with the
name 'Personal.xls' is already open. You cannot open two documents with
the same name, even if the documents are in different folders."

How do I make these shortcut keys work regardless of the order in which
my workbooks load? One way would be since Personal.xls loads last, I
could execute the application.onkey procedures there, but that is not
what I want because other people share this add-in I created, and I do
not want to share my personal.xls. I could also create a custom button
to do it, but I do not want to have to click a button every time i load
excel....

Does anyone have any suggestions? Any help would be most appreciated.


All times are GMT +1. The time now is 12:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com