You can turn off the automatic prompt if you so desire. Go to the Tools
menu, choose Options, then the General tab. There, uncheck the "Prompt for
documents" property. You can also create a new workbook, fill out the
properties (and nothing else) and save that workbook as a template (xlt) in
the XLStart directory (typically c:\program files\microsoft
office\office11\xlstart) with the name "book.xlt". New workbooks will be
created from book.xlt and therefore will have the default values for the
document properties already filled out.
--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
"abet_72" wrote in message
...
Hi All,
I have my properties tab popping up on every new document i save. It's
prompting me for either a documnet Title.
Does anyoe know of how to set a default for this area?
Thanks to anyone who can give me some insight into this frustrating
occurrance!!!