![]() |
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