keep one sheet activate - vba

[lezawang]

Hi
I have a sheet which has different control buttons (developer-->insert) and different macros are assigned to these buttons. I created a macro to move the sheets around. How can keep this sheet active even after moving it do different location (order, for example after sheet2 or 3 or 4 etc). I wrote this code

 worksheets(1).activate

but if the sheet moved to different location then it wont be sheet1 anymore. Thank you very much

 

[Fluff]

Use the sheet name, not the sheet index.