You could use an auto_open sub:
Option explicit
sub auto_open()
application.calculatefull
end sub
If .calculatefull isn't available to you (added in xl2k????).
You could use:
Application.SendKeys "%^{F9}"
Antonio Duarte wrote:
I created a function that reads data from other files and returns the result
in a cell. So, I would like to automatically force recalculation every time
my WB is openned.
How can it be done?
Tks.
--
Dave Peterson
|