Properties Greyed Out

D

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
 
D

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
 
C

Craig

doug said:
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
Click to expand...

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.
 
Top