Good morning,
I wrote a very simple addin to calculate a specific range, I would like it to work when I press "Ctrl + Q".
here is the simple code
I have to browse to addin and enable it everytime I re-open Excel.HTML Code:
Would you know how to keep it enabled, so that I can use it everytime I use Excel
thanks for in advance for your suggestion.
-Phil
You shouldn't have to add it every time you start excel assuming you are installing it rather than just opening it. Perhaps you have a permissions issue with your registry. A simple workaround would be to put the file in your XLSTART folder so it gets opened, rather than installed, automatically.
Everyone who confuses correlation and causation ends up dead.
thank you Romper Stomper, I'll try that and let you know. If I copy it in my XLSTART would it also remember the key shortcut "Ctrl + Q" ?
thanks again
Phil
Yes it should do - that information is saved in the code module.
I cannot find my XLstart folder, would you know, where it would typically be located?
There are two - one in your user folder (path varies by OS) and one in Program Files (x86)\Microsoft Office\Office12\XLSTART for Office 2007 on a 64 bit Windows.
got it thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks