View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Excel Properties Tab on Doc Save

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!!!