Rename workbook VBA is gone

[Myproblem]

i have some VBA code in some workbook that is run in "ThisWorkbook" procedure.
when i rename that workbook the VBA is gone.

any idea what to do to prevent this happening.

 

[wigi]

Can you please upload the file and some screenshots with a filesharing website? I still do not believe this.
Even more, it helps if you answer the questions I ask you (multiple times already).

 

[Myproblem]

i figure out what was wrong, resolved

it was all about sheet name in "Project - VBAProject", because
in my case Sheet19 (Sheet2), was appropriate name - i was wrong by searching for VBA result in sheet Sheet2(Table)

name missmatching,
thx guys for replaying

 

[Ruddles]

You win this week's

award!​

 

[Myproblem]

You win this week's​

​

award!​

yes i did