Regarding Macro's

[showry]

Hi All,

I am learning Macros,
I have recorded one macro in book1.xls then created one more macro in
book2.xls,

I would like to maintain all macro;s in one book only, so i have
copied the macro1 in book1 copied in book2 but with allocated shortcut
it is not working.. Pls give me a solution for the same.

Regards,
anil.

 

[FSt1]

Hi All,

I am learning Macros,
I have recorded one macro in book1.xls then created one more macro in
book2.xls,

I would like to maintain all macro;s in one book only, so i have
copied the macro1 in book1 copied in book2 but with allocated shortcut
it is not working.. Pls give me a solution for the same.

Regards,
anil.

hi
sounds like you are trying to create a personal.xls.
see these sites for info and tips on how to accomplish this.
http://office.microsoft.com/en-us/excel/HA010872961033.aspx
http://www.rondebruin.nl/personal.htm

regards
FSt1