Thread: Event Macro Calculate Does Not Work
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Carl Bowman Carl Bowman is offline
external usenet poster
  
Posts: 21
Default Event Macro Calculate Does Not Work
That worked! Thanks!

"Rowan" wrote:

Try

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

Hope this helps
Rowan

"Carl Bowman" wrote:

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.
Reply With QuoteReply With Quote