Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Tab Click
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Tab Click
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" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I click on a cell on one worksheet and make it take me to another worksheet | New Users to Excel | |||
on your main page click on the worksheet name and be taken to it | Excel Worksheet Functions | |||
Shortcut Key-Right Click Worksheet | Excel Discussion (Misc queries) | |||
Get points in a worksheet using mouse click | Excel Programming | |||
Copying Worksheet triggers Click event of combobox on another worksheet | Excel Programming |