Editing a user defined function

Topic

New Reply

I have previously created an “xlam” file containing some user defined functions. I can’t work out how to edit the file (so I can changed one of the functions). Any ideas? Thanks.

Reply | Quote

Replies

The xlam project should be visible in the VBE if you have it loaded, so you can alter the code there and then run a line of code like:

Code:

workbooks("addin name.xlam").save

from the immediate window.

Reply | Quote

The xlam project should be visible in the VBE if you have it loaded, so you can alter the code there and then run a line of code like:

Code:

workbooks("addin name.xlam").save

from the immediate window.

When I open the xlam file, nothing appears (and nothing appears in the “Switch windows” list)???

Reply | Quote

You won’t see it in the Excel UI because add-in windows are hidden. You need to open the VBEditor (Alt+f11), locate the add-in in the project explorer window (usually in the top left corner) and then double-click the module that you want to edit t view the code.

Reply | Quote