keep tracking sheet1 - vba

[lezawang]

Hi
I am adding/deleting/moving/copying sheets in one workbook. So the order of sheets get change, their names get change sometime, etc.
I have all Control buttons in Sheet1. So right now I can refer to that sheet as

Sheets(1)
Sheets("sheet1")

but lets say later on I changed the order of the sheets so it wont be sheet 1 anymore, and also change the name of all sheets so it is not sheet1 anymore. Is there any way to hard code the name of a sheet so I can always using it no matter what happen. Thank you.

Thank you.

 

[Fluff]

You can use

ActiveSheet

 

[lezawang]

Thank you for your reply. But it wont be the active one once I insert different sheets (add) or when I copy sheets etc. Thanks

 

[Fluff]

If you have a button on Sheet1 & Sheet2 is active, how do you click on the button?

 

[lezawang]

Yes that is the problem. I have all buttons in sheet1 then when I insert different sheets/copy/delete/add etc the active sheet wont be sheet1 anymore. My question is there an hardcoded number or name of a sheet in excel? because in my case sheet1 can move and be sheet3 and also its name might change from sheet1 to Mysheet for example. Thanks once again.

 

[Fluff]

The sheet with the buttons (regardless of name or position) has to be the activesheet in order to click the button.

 

[lezawang]

true. Did not think about that. Thank you so much.

 

[Fluff]

You're welcome