How do I add properties to add-in ?

[Marc Hillman]

I'm using Excel 2007, and I have written an add-in (.xla) with a single
macro that works fine. It is located in the default add-ins folder. I now
find I'd like to add in the Title & Comments properties, but I cannot get
access to these. When I open the .xla file the "Prepare" option is greyed
out, and when I use Windows Explorer to view the file I cannot modify the
Comments or Title field.

This must be simple. What could I be doing wrong ?

 

[RadarEye]

Hi Marc.

When youe XLA is in the default add-in folder it is automaticly
started, running and protected.
Move you XLA to a different folder and open it from there.
Where you have added the new properties move it back to the default
add-in folder.

HTH,

Wouter.

 

[Doug Glancy]

Marc,

I think if you uncheck the addin, or just close Excel, you'll be able to get
at them in Windows Explorer.

hth,

Doug

 

[Marc Hillman]

Neither suggestion works I'm afraid. I even changed the file extension to
..xls, but still no access to Properties

 

[royUK]

Have you protected the addin's VBA Project

--
royU

Hope that helps, RoyUK
For tips & examples visit my 'web site
' (http://www.excel-it.com

 

[Marc Hillman]

Neither solution suggested works I'm afraid. Any other ideas?

 

[royUK]

Not sure if affects what you are doing, but the extension for a 200
addin is *.xla

--
royU

Hope that helps, RoyUK
For tips & examples visit my 'web site
' (http://www.excel-it.com

 

[Marc Hillman]

Genius. I am targetting an Excel 2003 environment, but I just changed the
extension to .xlam, and voila! - I can change all the properties. Have
changed back to .xla and properties are there.