Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 829
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Set macro security level to 'low level' on opening a certain workbook. andreashermle Excel Programming 2 November 15th 10 06:33 AM
Before Workbook Event, Custom Calculate a Specific Worksheet jeffbert Excel Programming 6 July 14th 08 05:17 PM
workbook level name vs worksheet level name clara Excel Programming 1 September 19th 07 02:32 PM
How to determine the worksheet that a calculate event gets initiated on when the workbook is not active Riddler Excel Programming 2 May 16th 07 01:58 PM
Why, when I create workbook-level name does it jump it to Sheet-level ? Charles Jordan Excel Programming 1 November 5th 03 08:43 PM


All times are GMT +1. The time now is 05:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"