View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Richard Richard is offline
external usenet poster
 
Posts: 709
Default Changing sheets after the DeActivate Event.

MS XP, Excel 2003
I am using the DeActivate event to sort the page Im currently on. When I
select any other sheet the present sheet deactivates and sorts properly.
The problem is when the sort completes it returns to the page that was
sorted and not the one selected B/4 the present sheet was deactivated.
How can I store and select the page I want when the sort is completed?

Thanks in advance.

--
Richard