MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 95 events


Posted by sheeba on February 17, 2001 10:37 PM

Hi ,
could anyone pls help me..
I have to get excel 95 events in a vc application??how??Especially sheet inert and delete events..
I have already done it in excel 97..But 95 what are these events??how??

TIA,
Sheeba


Posted by David Hawley on February 17, 2001 11:08 PM


Hi sheeba

I don't think 95 has these Events, you will have to create them as a new object in a class module.

97 onwards has:

Private Sub Workbook_NewSheet(ByVal Sh As Object)

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)

These can be foud by right clicking on the sheet picture, top left next to "File" and Selecting "View Code"

DaveOzGrid Business Applications