activate, window activate?

  • Thread starter Thread starter John
  • Start date Start date
J

John

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?
 
Try this. Hope this helps! If so, let me know, click "YES" below.

Private Sub Workbook_WindowDeactivate(ByVal Wn As Excel.Window)
Range("V3").Font.ThemeColor = xlAutomatic
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embedded charts with events not working? 0
Stop Active Cell from Firing Event after Hitting Return 1
Save workbook needs to be added Please 2
Sheet change event not triggering macro 3
Worksheet sorting code/technique advise 55
How to publicly set a variable? 2
Macro to Activate a Macro 6
If no activity, display a UserForm; 10 seconds later close Workboo 4

Back
Top