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 ?

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.

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" wrote in message
...
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 ?

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

Have you protected the addin's VBA Project?


--
royUK

Hope that helps, RoyUK
For tips & examples visit my 'web site
' (http://www.excel-it.com)
------------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=33214

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

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
-----------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=3321

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.
"royUK" wrote in message
...

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


--
royUK

Hope that helps, RoyUK
For tips & examples visit my 'web site
' (http://www.excel-it.com)
------------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=33214