Automatically execute a CTRL-ALT-F9 when I open a workbook

A

Antonio Duarte

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.
 
D

Dave Peterson

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}"
 
Top