Internal Spreadsheet and VBA Macro

[budanod]

Hello !

I just spend a lot of time to search informations about my problem but I didn't found anything..

Actually, I'm trying to create a model in NX (a Spring) which have links with the internal spreadsheet of the part. The goal is to calculate mecanicals propreties according to the part dimensions.

I have created all parameters in "Tools->Expressions", than I was in "Tools->Spreadsheet->Add-ins->Extract Expr".

I have created a new sheet with all calculations and a nice layout. Now I have created some macros in order to have a both sides values updating (when I change a value on the Calculation sheet it will update the "NX Sheet" and then the part and when I'm opening the Internal Spreadsheet, if I have changed values in "Expressions" the calculation sheet is updated).

My problem is : When I'm leaving the Spreadsheet, all my VBA Code is not saved...

How can I fix it ?

For informations, I'm using NX 6.0.5.3.

Thanks for your help and sorry for my english..