XLSX file

[BJH1995]

Hi All,

My understanding is that when saving a wb containing VB code as an xlsx this
would remove any code?

I have saved a list of workbooks as xlsx but these still contain modules and Msgbox's on leaving the workbook. Could anyone explain a reason for this?

Thanks,

 

[Fluff]

My understanding is that when saving a wb containing VB code as an xlsx this
would remove any code?

That's right, but only once the workbook has been closed.

 

[BJH1995]

ah seems your right, when i re-enter the workbook and close it , it removes the code. Thank you

 

[Fluff]

You're welcome & thanks for the feedback.