how to capture the event changing the name of a sheet

's Computer Specifications

I would like to trigger a procedure whenever a user change the sheet name or
add anew sheet. The event of new sheet can be captured but I don't know how
to capture the event changing sheet's name.

Please help

's Computer Specifications

No event is generated when a sheet changes names... What were you needing the
event for? Perhaps we can help you get around the problem.
--
HTH...

Jim Thomlinson

"Satyapal Kaushal" wrote:

> I would like to trigger a procedure whenever a user change the sheet name or
> add anew sheet. The event of new sheet can be captured but I don't know how
> to capture the event changing sheet's name.
>
> Please help

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sheet Rename event capture	Venkat	Microsoft Excel Discussion	2	18th May 2009 04:41 PM
Copy Sheet causes Combo Box change event to fire on original sheet	AJ Master	Microsoft Excel Programming	0	10th Nov 2008 07:49 PM
Can you capture an event for ref in the code of the next event	=?Utf-8?B?c2lzeXBodXM=?=	Microsoft Access Form Coding	4	19th May 2006 06:20 AM
How to capture the event before any sheet calculating in Excel	JohnDing	Microsoft Excel Programming	1	23rd Dec 2004 03:04 AM
How to capture the event before any sheet calculating in Excel	JohnDing	Microsoft Excel Programming	0	23rd Dec 2004 01:00 AM