Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculate(f9) event at workbook level?
hello,
Is the such an event at the workbook level and not only at a sheet level? I want the event fired independently of the active sheet Thanks Avi |
#2
|
|||
|
|||
Quote:
Ctrl-Alt-Shift-F9 This is the equivalent of: Application.CalculateFull in VBA It re-calculates ALL open workbooks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculate(f9) event at workbook level?
You need:
Ctrl-Alt-Shift-F9 This is the equivalent of: Application.CalculateFull in VBA It re-calculates ALL open workbooks Paga Mike Thanks Mike, but I am looking at firing the F9 at the workbook (something as Workbook_Calculate...) Avi |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculate(f9) event at workbook level?
"avi" wrote:
Is the such an event at the workbook level and not only at a sheet level? I want the event fired independently of the active sheet There is the Workbook_SheetCalculate event macro. It is called after __each__ worksheet is recalculated -- and after that worksheet's Worksheet_Calculate event macro is called, if any. So it is called multiple times when we press ctrl+alt+F9, for example. That might not meet your needs if you want an event that is called only once after __all__ worksheets are recalculated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set macro security level to 'low level' on opening a certain workbook. | Excel Programming | |||
Before Workbook Event, Custom Calculate a Specific Worksheet | Excel Programming | |||
workbook level name vs worksheet level name | Excel Programming | |||
How to determine the worksheet that a calculate event gets initiated on when the workbook is not active | Excel Programming | |||
Why, when I create workbook-level name does it jump it to Sheet-level ? | Excel Programming |