Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatically execute a CTRL-ALT-F9 when I open a workbook
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. |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I automatically open linked documents in Excel? | New Users to Excel | |||
Execute Macro automatically after hyperlink | Excel Discussion (Misc queries) | |||
Automatically open excel file after log in | Excel Discussion (Misc queries) | |||
Find (Ctrl +F) not searching all open sheets | Excel Worksheet Functions | |||
How can I set up a Macro to automatically run when I open a speci. | Excel Discussion (Misc queries) |