Worksheet Tab Click

[don]

I need to make a single left click on a worksheet tab
start some code.
I don't know if this is possible, but if it is, then the
code syntax for the 1st line of the module has me beaten.
I've tried:-
"Private Sub Worksheet1_Click()"
(and other syntax), but it doesn't respond to the Tab
click.
Can anyone please help.

 

[Chip Pearson]

Don,

There is no event for clicking a worksheet tab, as such. You
might be able to use the Activate event of the worksheet, which
will fire when you click from one sheet to another, but not when
clicking the tab of the active sheet.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[don]

Yes. Thanks Chip. Using the WS Activate event (which
happens when I hit the WS tab ) and putting the code I
need in there does the trick.
Thanks again
Don