Thread: How to determine the worksheet that a calculate event gets initiated on when the workbook is not active
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Riddler Riddler is offline
external usenet poster
  
Posts: 49
Default How to determine the worksheet that a calculate event gets initiated on when the workbook is not active
I did find this code to work.
Private Sub Worksheet_Calculate()
MsgBox Sheet1.Name
End Sub

The only thing I had to change "Sheet1" to match the sheet it was on.
It works at least.

Scott

Reply With QuoteReply With Quote