View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Pauld Pauld is offline
external usenet poster
 
Posts: 8
Default VBA Auto_Activate

Norman,
Thanks for taking the time to help out. I've been using a book by Jeff Webb
and,
after reading your post I took a look at it's publication date. 1996! Yikes!
In there he listed 4 "auto" procedures.

Auto_Open
Auto_Close (for Workbooks)
and Auto_Activate
Auto_Deactivate (for Worksheets).

The article you pointed out is the way I will go. (Haven't done it yet but
I'm sure its the right thing). BYW Auto_Open and Auto_Close still seem to
work w/ Excel 2003.

Jim-- Thanks to you also. If you look a Norms posting, you'll see that I
wasn't trying
to associate a procedure w/ a range or cell but with the action of
activating an object such as a Worksheet.

P.S. I'm awaiting delivery of 3 or 4 programming guides from Amazon---on
Excel 2003! No more foolishness I hope!