Also, see Chip Pearson's page on events
http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy

"Chaplain Doug" wrote in message
...
Dear Don:

Its just like I told Bob: I have been doing VBA programming (hacking) for
quite some time now and had NEVER used this feature. I feel like the guy
who
was struggling for hours to cut down a tree with a chainsaw, and who had
someone come up and start the chainsaw for the first time. I've been
cutting
without ever starting the chainsaw! And I ain't no dumb hillbilly
neither.
Well I do live in the hills and some people call me "Billy," but other
than
that . . . Thanks and God bless.

"Don Guillett" wrote:

Have you looked within the controls.
sheet tabview codeleft windowworksheetright window see events

--
Don Guillett
SalesAid Software

"Chaplain Doug" wrote in
message
...
Excel 2002-2003. What events may be trapped in VBA for an Excel
workbook
and
its worksheets? For instance, I have an event routine:

Private Sub Workbook_Open()

Which runs when the workbook is opened. That is the only event I know
the
name of. Are there events for when I change from sheet to sheet? Are
there
events when a particular sheet is activated (selected)? Also, I am
trying
to
set up a menu with control buttons, etc. I want to hide the cursor
(box)
so
that I do not have a black box outline show up on the page. I use
Sheets(<sheetname).ScrollArea="E7" to hide the "cursor" behind a
control.
Is there a better way to do this? Thanks for the help.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org