LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default Event Macro Calculate Does Not Work

I need a macro to run the application "EnterTitle" any time the workbook is
recalculated, whether it be manually using F9, or automatically, when any
cell changes if the calculation mode is in automatic. I entered the following
syntax by right-clicking the Excel logo and selecting "View Code" but this
does not work.

Sub Workbook_Calculate(ByVal Sh As Object)
Application.Run "EnterTitle"
End Sub

Thanks in advance.
 
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
Macro doesn't work when used as Workbook Open event Phil Excel Discussion (Misc queries) 2 October 20th 06 02:42 PM
Change event and calculate event Antje Excel Programming 1 March 29th 05 09:03 PM
AFTER Calculate Event PosseJohn Excel Programming 4 January 16th 05 07:31 PM
Sometimes range calculate doesn't work in macro. Why? Don Wiss Excel Programming 3 January 4th 05 05:37 PM


All times are GMT +1. The time now is 07:17 PM.

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"