Document a .xla file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everyone,

I have an addin that contains over 20 modules and about 24000 lines of code.
I would like to document it with Rob Bovey's Code Documentor but I can't
because there is no Excel workbook open.

How can I convert this .XLA to a .XLS so I can run the application?

Thany for your help.
 
Hi Juan,

How do I access this property and how do I change it?

Thank you for your concern.
 
While in the VBE, press Ctrl R to show the Project Explorer. In there,
browse to your xla, and then select the "ThisWorkbook" module. When you
have it selected, press F4 to display the properties. In there you'll see a
list of the properties available. Change the 'IsAddin' from True to False.
 
Just to Add to this..... don't forget to set it back to True and sav
it.
Save this while in the VBA Editor. ie. File > save... or use the sav
icon
 
Back
Top