Adding event when sheet created

's Computer Specifications

Hi,

I'm working in VB 6.0 for Excel 2002.

How do I add an event for when a "Sheet 1" is created?

Thanks for your help,

Barry

's Computer Specifications

programmatically? See http://www.cpearson.com/excel/vbe.htm#CreateEvent

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
>
> I'm working in VB 6.0 for Excel 2002.
>
> How do I add an event for when a "Sheet 1" is created?
>
> Thanks for your help,
>
> Barry
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy Sheet causes Combo Box change event to fire on original sheet	AJ Master	Microsoft Excel Programming	0	10th Nov 2008 07:49 PM
easy question no source is created when a custom event is created	TonyJ	Microsoft C# .NET	0	30th Oct 2007 03:22 PM
how to stop created sheet from linking to another sheet	Dwayne	Microsoft Excel Programming	2	13th Nov 2006 01:51 PM
Adding event handler for dynamically created controls	=?Utf-8?B?QW5kcmV3IFdpZWQ=?=	Microsoft ASP .NET	3	25th Apr 2004 08:36 PM
Shared border created in FP 2003 and adding to the pages created in FP 98	=?Utf-8?B?TXIuIFNoYWg=?=	Microsoft Frontpage	4	9th Jan 2004 10:58 AM