activate, window activate?

's Computer Specifications

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?

's Computer Specifications

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
--
Cheers,
Ryan

"John" wrote:

> 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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Reliably activate PowerPoint, do something, Activate Excel	Barb Reinhardt	Microsoft Excel Programming	1	4th Dec 2008 09:42 PM
Can't Activate - Clicking Activate Windows Does Nothing :(	war59312	Windows Vista General Discussion	1	6th Mar 2007 07:31 AM
Windows().Activate vs Workbooks().Activate	=?Utf-8?B?R2FyeScncyBTdHVkZW50?=	Microsoft Excel Programming	4	6th Nov 2006 02:01 PM
What's this? "Press spacebar to activate or enter to activate....	=?Utf-8?B?Rm9yU3VyZQ==?=	Microsoft Outlook Discussion	3	13th Apr 2006 09:12 PM
Workbook.Activate / Window.Activate problem	Tim	Microsoft Excel Programming	3	3rd Feb 2006 11:38 PM