View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] caraj@cox.net is offline
external usenet poster
 
Posts: 2
Default Activating macro by leaving a spreadsheet

I wrote a routine Sub In2Out( )

To activate In2Out( ) I have to go to tools, macro, run or assign a
cntrl + key.
I wish the macro to execute when I deactivate worksheet IN (The
workbook has 2 worksheets IN and OUT).
The event App_SheetDeactivate does what I want but it requires a right
click on the worksheet tab - an extra key click.
So I'm back to needing a way to execute the macro by deactivating work
sheet IN.

Thanks ahead of time,
John