Hey all,

Someone else in this forum wrote this about sharing macros over network:

Essentially, all you do is put all your code in a new workbook, and then do
a SaveAs with a file type of xla (at the foot of the list). The xla file is
then installed (Tools>Add-Ins>Browse and find it).

There is no way to save as xla file from save as menu in excel 2007.

Thanks for response.