As we can have changes in word permanently by changing the Normal.dot file.
But in excel, is it possible to make this kind of changes.

As i have made a module (spellnumber) in one of my excel file but this
module works only within the file where it has been created.

I have to import that module in each file where i want to use this
spellnumber formula. Is there anyway that i could save this module in the
main excel program that when-ever i run excel the spellnumber should work in
it...

Thanks and Regards

Shakeel Ahmad.

Please answer this question






"Shakeel Ahmad" wrote in message
...
As we can have changes in word permanently by changing the Normal.dot
file. But in excel, is it possible to make this kind of changes.

As i have made a module (spellnumber) in one of my excel file but this
module works only within the file where it has been created.

I have to import that module in each file where i want to use this
spellnumber formula. Is there anyway that i could save this module in the
main excel program that when-ever i run excel the spellnumber should work
in it...

Thanks and Regards

Shakeel Ahmad.

Excel doesn't have a normal.dot.

It can have a template file (book.xlt) that can be used for lots of
things--headers/footers. But it's not usually used for macros.

But you can create your own utility workbook that has all the macros that you
want. Store it in your XLStart folder and it'll open each time excel opens.

Many people name this file personal.xls and make sure the workbook's windows are
hidden--so it doesn't confuse them.

And if that spellnumber is a function, you'd use a formula like:

=personal.xls!spellnumber(a1)



Shakeel Ahmad wrote:

As we can have changes in word permanently by changing the Normal.dot file.
But in excel, is it possible to make this kind of changes.

As i have made a module (spellnumber) in one of my excel file but this
module works only within the file where it has been created.

I have to import that module in each file where i want to use this
spellnumber formula. Is there anyway that i could save this module in the
main excel program that when-ever i run excel the spellnumber should work in
it...

Thanks and Regards

Shakeel Ahmad.

--

Dave Peterson