Tina,
I would consider the idea of building a separate template workbook (*.XLT)
that is saved in the Templates directory. All normal calculations and UDF's
would be contained in this template (along with any event handlers, if
needed). In this way, all of the problems of re-entering formulas with a VBA
routine of some sort simply go away. The routines that we suggested are no
longer needed. You could include and use array formulas, embedded charts,
etc. all you want.

Put all common code that supports a toolbar or custom menu into an add-in
(*.XLA). It can initially be developed as a separate workbook (*.XLS), then
saved as an add-in once all the code works the way you want it. In making
the add-in, you only have to add a few short lines of code in the
Workbook_AddinUninstall event to delete any toolbar that was attached when
the add-in was installed.
--
Regards,
Bill


"Dave Peterson" wrote in message
...
It didn't when I tried it.

But you could look for a formula and look for an array:

With ActiveCell
If .HasFormula Then
If .HasArray Then
.FormulaArray = .FormulaArray
Else
.Formula = .Formula
End If
End If
End With



Bura Tino wrote:
<<snipped


So from studying the thread I'm concluding that .Fomula = .Formula is a
legtimate trick.

Will this work if the cell has an array formula?

<<snipped

--

Dave Peterson