+ Reply to Thread
Results 1 to 2 of 2

Naming a file immediately

  1. #1
    Registered User
    Join Date
    06-03-2010
    Location
    Tyngsboro, MA. USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Naming a file immediately

    I have many users who are not very disipline. Often when they use a template they forget to name it and save the "generic blank template" after they've munipulated it. Is it possible to force the Save As window to appear immediately upon opening a template and forcing the user to rename the file before munipulating?

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481

    Re: Naming a file immediately

    This can be done with VBA, but then macros would have to be enabled when the workbook is opened.

    A sure way would be to set the Template as read only, then they would have no choice but to save it in a different name.
    Hit F12
    Goto Tools> General Options and set to read only.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1