Properties Greyed Out

[doug]

Hello...

In a lot of my Excel sheets when I open them and go to
the File menu, the properties button is greyed out. Any
idea why? Some of these sheets have macros and some of
them don't. Other Excel files are fine.

thanks

doug

 

[jammy]

are those workbooks protected

 

[doug]

Yes, I figured it out just after I posted. Thanks.

The reason I am asking is that Indexing Service does
index the properties correctly when a workbook is
protected. That's my real issue...

When a result set comes back, it inserts "no title" in
the result set of documents...

doug

 

[Craig]

Hello...

In a lot of my Excel sheets when I open them and go to
the File menu, the properties button is greyed out. Any
idea why? Some of these sheets have macros and some of
them don't. Other Excel files are fine.

thanks

doug

Usually the General tab of the Properties window will be greyed out if
the file is unsaved. Once it is saved the properties will show. You
will have the same issue if your workbook starts out as a template.
Let me know if Save doesn't work.