ExcelBanter - Events

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Events (https://www.excelbanter.com/excel-programming/314367-events.html)

ojv[_2_]

Events

Is there any way to trap changes in sheet index via an event?

ojv

Mike Fogleman

Events

I think you mean select a different sheet. If so, in ThisWorkbook events
there are Sheet_Activate and Sheet_Deactivate.

Mike F
"ojv" wrote in message
...
Is there any way to trap changes in sheet index via an event?

ojv

Chip Pearson

Events

Unfortunately, there is no event for moving or renaming a
worksheet.

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

"ojv" wrote in message
...
Is there any way to trap changes in sheet index via an event?

ojv

ojv[_2_]

Events

thx.

"Chip Pearson" wrote:

Unfortunately, there is no event for moving or renaming a
worksheet.

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

"ojv" wrote in message
...
Is there any way to trap changes in sheet index via an event?

ojv

All times are GMT +1. The time now is 02:30 AM.