Which Event do I need?

[Hattie]

Hello,

where would i put a macro to sort column A automatically when i select a sheet?

so, if i am on sheet 1 and switch to sheet 3 i want whatever is in column A of sheet 3 to sort itself alphabetically, without me having to click anything.

would it be a workbook change event?

or is it a worksheet event?

I still find i put code in wrong events and end up moving it around, still need to get my head around this.

thank you

 

[Tetra201]

Try using Worksheet_Activate.

 

[Hattie]

Thank you

 

[Tetra201]

You are welcome.