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.
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks