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