Hi, thanks in advance for any help.

I have a personal.xla addin where I store all my simple macros (ie Paste values; increase font size; set font color to blue etc etc). When I start excel 2003 it is automatically loaded and the code is available to every worksheet I edit.

I'd like to set some shortcuts so that if I press, say, ctrl + shift + s, a macro gets executed but I don't know how to do it.

If I copy all the VBA code from my addin into the worksheet then i can use the macro menu to set the keyboard shortcut but copying all the macros is exactly what i'd like to avoid keeping them centralized in a single add-in file.

is there a way to solve this ?

any support would be very much appreciated

Thanks

Paolo

Italy