you always have to programm accesibility into your .xla add-ins THEY ARE NOT
REGULAR WORKBOOKS and you can not access the macros the same way, I reccomend
going into your add-in programming and adding a liine similar to this
in the workbook open even

private sub workbook_open()
application.onkey "^{j}","MyAddIn.xla!MyMacro"
end sub
this will assign your macro to ctl+j


then in close event
to restore ctl + j to normal function


private sub workbook_cancel()
application.onkey "^{j}",""
end sub


--
When you lose your mind, you free your life.
Ever Notice how we use '' for comments in our posts even if they aren''t
expected to go into the code?


"Brett Smith" wrote:

I wrote a VBA program to format text and then export a txt file with
information formatted in a certain way. My problem is I tried to install the
XLA file, i think I did, I saw that I was able to see it on the Add-In list.
Then I tried to use it on a brand new spreadsheet to test it. Long and
behold, I cannot use it because I don't know how to find it in order to use
it. How do I activate it and how do I get it to work without opening up the
old file that has all the code. This is a REAL PAIN IN THE REAR. This is
the worst I have seen in usability with Microsoft.

"ben" wrote:

could you be a little more specific, what did you write it to do, and what is
it not doing and what is it doing?

--
When you lose your mind, you free your life.
Ever Notice how we use '' for comments in our posts even if they aren''t
expected to go into the code?


"Brett Smith" wrote:

I wrote a program and then saved it as an XLA file in order to use it as an
Add-In so it can be used for any spreadsheet. For some reason, it is not
working for me and I thought things should be a whole lot easier. What is
the problem here and what is a step by step process in order for me to get it
to work. Somebody please help me because I really need the help. Thanks!

Brett