VBA Code not saved in Workbook

[Former Member]

After making changes to VBA code I save the workbook, and then I disconnect and open the workbook again the changes I made to the code are not there. I am not sure what else needs to be done in order to save the VBA code along with workbook.

I have Excel2007 and Analyzer 7.10 SP 9 Patch 1.

Any ideas/help will be really appreciated.

thanks!

[Former Member]

Hi ,

You need to write the VBA code in SAPBEX(sapbex.xla).

But it is password protect , i'm not sure you can provide this password.

cheers

Sukhi

[Former Member]

Hi Sukhi,

Thanks for your answer. I was able to write VBA code in the project which gets created for the workbook itslef not sapbex.xla.