Posted to microsoft.public.excel.programming

external usenet poster

Posts: 206

Trigger macro when nr of sheets changes

Hi There,

I would like to trigger a maco when the nr of sheets in the active
workbook changes ...

Not: Private Sub Workbook_NewSheet(ByVal Sh As Object)

As this triggers only when a New ("Blank") Sheet is inserted.
But it should fire as well when I make a copy of an existing sheet(s).

Please?

Best Regards, Sige

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
Trigger Macro by Worksheet_Change	JSnow	Excel Discussion (Misc queries)	5	October 2nd 08 06:27 PM
macro trigger	Leslieac	Excel Discussion (Misc queries)	3	February 2nd 06 09:08 PM
Trigger a Macro in MS Access from an Excel Macro?	DonRetd	Excel Programming	13	March 30th 05 09:52 PM
Macro trigger?	No Name	Excel Programming	3	February 29th 04 05:24 PM
Macro trigger?	excelguru	Excel Programming	0	February 29th 04 06:10 AM

All times are GMT +1. The time now is 11:12 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us