Hello,
I have a worksheet which shows up in the "Project- VBAProject" window as:
Sheet1(My Name)

I want to turn this worksheet to invisible , tried this code:
Sheets("My Name").visible= False
which works as long as I don't change the worksheet name.

My question is , what would be the code to refer to this worksheet by "Sheet1" name, regardless of the worksheet position from left to right in the workbook.

Thanks