LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 127
Default Workbook and Worksheet Events

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Understand Workbook/Worksheet Events Zamdrist Excel Discussion (Misc queries) 4 August 10th 06 04:56 PM
Workbook Events Don Lloyd Excel Programming 2 September 9th 04 02:55 PM
How to handle other workbook events through personal.xls workbook ivarsb Excel Programming 1 July 27th 04 01:35 PM
Workbook Events Geoff[_8_] Excel Programming 0 September 13th 03 09:28 AM
Events for workbook close Aaron Queenan Excel Programming 6 July 15th 03 09:09 PM


All times are GMT +1. The time now is 04:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"