View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John John is offline
external usenet poster
 
Posts: 2,069
Default activate, window activate?

Hi, I want code to fire when I deactive excel and select another program and
then run again when I active excel again...

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
Range("v3").Font.ThemeColor = xlAutomatic
End Sub

Tried several, what am I missing?