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
Bookmarks