How to listen to "rename sheet"

Posted to microsoft.public.excel.programming

Ben[_12_]

external usenet poster

Posts: 2

How to listen to "rename sheet"

Hi

I'd like to create a listener on the event "sheet.name changing". It
apparently does not exist in vba worksheet standard callbacks.
(said in a different way I want to run a function any time a specific
sheet has its name manually changed)
Any idea ? Any help would be appreciated.

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell	Steve Kay	Excel Discussion (Misc queries)	2	August 8th 08 01:54 AM
Excel "Move or Copy" and "Delete" sheet functions	dsiama	Excel Worksheet Functions	1	December 28th 07 01:57 PM
Change default in input box from "20" to "000000"? Have macro continue on to name sheet tab?	StargateFanFromWork[_4_]	Excel Programming	7	October 29th 06 11:46 AM
Please add a "sheet" function like "row" and "column" functions	Spreadsheet Monkey	Excel Programming	2	November 8th 05 04:08 PM
How to use macro to rename worksheet with date +"text"	Sherri[_3_]	Excel Programming	4	April 28th 04 12:05 AM

All times are GMT +1. The time now is 07:47 AM.

Menu

About Us