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 |
Quote:
Ctrl-Alt-Shift-F9 This is the equivalent of: Application.CalculateFull in VBA It re-calculates ALL open workbooks |
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 |
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. |
All times are GMT +1. The time now is 06:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com