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.

 

[Yahya]

make sure from Extension XLSM not XLSX

 

[wigi]

What do you understand by renaming? I assume it's not the rename in Windows Explorer, for instance?

 

[Myproblem]

thx for replaying
@ Yahya i did that in xlsm format - i am familiar with it

@ wigi it is changing the name of entaire workbook, for instance original name was Name1.xlsm (vba code working)
second name is Name2..xlsm (vba cod is not working)

i have read somewhere about preventig sheet naming to make sure that specific macro is "linked" to specific sheet name and i do not know where i read about it to figure out about problem above

 

[Ruddles]

Originally you said the VBA code was gone. Now you say it's not working.

Which is it?

 

[Myproblem]

Originally you said the VBA code was gone. Now you say it's not working.

Which is it?

sorry, mistake
the vba code is gone

 

[Ruddles]

Renaming your workbook in Windows Explorer won't delete any code that's in that workbook.


Are you saying:-

• the code is in Name1.xlsm
• you save and close Name1.xlsm
• you rename it Name2.xlsm
• you open Name2.xlsm
• you open the VBA editor and the code has gone

Is that what's happening?

 

[Myproblem]

Renaming your workbook in Windows Explorer won't delete any code that's in that workbook.



Are you saying:-

• the code is in Name1.xlsm
• you save and close Name1.xlsm
• you rename it Name2.xlsm
• you open Name2.xlsm
• you open the VBA editor and the code has gone

Is that what's happening?

yes it is, i rename it from Name1.xlsm (closed workbook) to Name2.xlsm and VBA code has gone

 

[wigi]

Hello

Strange case this one...

Where do you rename the workbook? In Windows Explorer, using Ctrl-O in Excel, other method? There is no code involved with the renaming?

 

[Myproblem]

Hello

Strange case this one...

Where do you rename the workbook? In Windows Explorer, using Ctrl-O in Excel, other method? There is no code involved with the renaming?

the VBA code is in Name1.xlsm, ThisWorkbook procedure
after I close workbook Name1.xlsm and rename it into Name2.xlsm, no VBA code in that (Name2.xlsm) workbook