If a worksheet is copied to my workbook it needs to be moved automatically to the 4th position - how?

[gravanoc]

I've built a workbook that has 3 mandatory worksheets in it, and they should always be the first three in the sheet index. This is easy enough to accomodate for when a new sheet is created, but I'm having trouble determining how to intercept these incoming sheets should the user decide to place the newly moved sheet before the mandatory ones. The only events that trigger are Workbook Deactivate & Workbook Window Deactivate, but neither have parameters that will take a sheet.

Any ideas? Thanks.

 

[Michael M]

How is the incoming sheet received in the workbook, by macro, copy / paste ??

 

[gravanoc]

How is the incoming sheet received in the workbook, by macro, copy / paste ??

It's the command where you right click a tab and manually move or copy it to your preferred slot either in the same workbook or a new one. Not on my computer or I'd screenshot it.

 

[Jaafar Tribak]

Use the sheet activate event to detect when the sheet is copied\moved and run your code.

 

[gravanoc]

Thanks, I'll give it a try.

 

[gravanoc]

Can confirm that it works for me. Thanks again Jaafar!