Update the VBA code in a XLA file

[Jeevie]

Hi All

I am unable to update the VBA code in an XLA file. After closing the file the changes are lost.

Can someone help ?

Thanks in advance.

[JKwan]

This may sound dumb, but did you save the xla file?

[Jeevie]

Yeah, i have the existing xla file where i need to make some changes. But even after making the changes, when i reopen, the updates are not visible.

[Paul_Hossler]

I am assuming that this is an 2003 XLA, I don't have my copies any more so this is from memory

You have to make it a normal .xls file first

I think in the VBE in the Properties window
If you select the XLA, there's a 'IsAddin' property that you can change
If I remember right, that will make it just like any hidden workbook that you can un-hide it as you would any normal workbook
Then save is as FileType = xls

Make your changes and save the XLS version, and then FileSaveAs an XLA version

Paul

[Bob Phillips]

The property Paul refers to is in the ThisWorkbook object.