Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
problem with Application.ScreenUpdating | Excel Programming | |||
application.onkey doesn't work | Excel Programming | |||
Application.OnKey problem | Excel Programming | |||
Application Problem | Excel Programming | |||
capture users Application.OnKey | Excel Programming |