Consulting

Results 1 to 7 of 7

Thread: Excel Property Window While Saving

  1. #1
    VBAX Contributor
    Joined
    May 2010
    Posts
    106
    Location

    Excel Property Window While Saving

    Dear All,

    How I can rid from the Property Window when saving excel file first time?

    Screen0201.JPG

    Reg,
    RL

  2. #2
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    Display the Properties dialog box when saving workbooks



    To help organize your workbooks so that you can find them easily later, you can set file properties for the active workbook. If you want to be reminded to set file properties for every workbook you create, you can have Microsoft Excel display the Properties dialog box when you save a workbook for the first time.

    For more information about file properties and their purpose, click About file properties in the See Also section of this topic.


    1. On the Tools menu, click Options, and then click the General tab.
    2. Select the Prompt for workbook properties check box.


    Note The Properties dialog box will be displayed after you click Save in the Save As dialog box whenever you save a file for the first time, or when you click Save As on the File menu to save the file with another name.
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  3. #3
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,956
    Location
    What version of Excel? That is not normal. There may be an option that is forcing the display for Custom Properties most likely. Read about that in: http://www.addintools.com/documents/...ties.html#2010

  4. #4
    VBAX Contributor
    Joined
    May 2010
    Posts
    106
    Location
    I am using excel 2010.

    I am seeing above guidelines...

  5. #5
    VBAX Contributor
    Joined
    May 2010
    Posts
    106
    Location
    I cant find a solution in given guideline due to excel 2010version!

  6. #6
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,956
    Location
    Have you looked at File > Info > Properties? Properties is on the far right of the backstage view.

  7. #7
    VBAX Contributor
    Joined
    May 2010
    Posts
    106
    Location
    Yes, I saw that but do not find the way that does not prompt me when saving workbook.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •