+ Reply to Thread
Results 1 to 4 of 4

Force Save As for master file for other users

  1. #1
    Registered User
    Join Date
    03-08-2018
    Location
    Derbyshire, England
    MS-Off Ver
    Excel 2016, Office 365
    Posts
    33

    Force Save As for master file for other users

    In order to prevent users overwriting my blank master workbook I want to force users to "Save As" so they can't save the workbook with the same name as the master file. I've found some VBA code to do this, which works great, but it also stops me from modifying my file and saving it as the name of the master file. I need to make other users 'Save As', but still allow me to Save as normal.

    The code I'm using for the 'Save As' is this:

    Please Login or Register  to view this content.
    I think I can use this to check whether the user is me or not, but as a newbie to VBA whose VBA skills are basically copy/paste blocks of code found online and tweak the odd word here or there, I'm not sure how this would fit in with the original code and where I'd need 'Else', 'End If' and such like. At the moment I get compile errors when I try and add this after the 'Private Sub Workbook_BeforeSave':

    Please Login or Register  to view this content.
    Any advice gratefully received.

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,821

    Re: Force Save As for master file for other users

    An easy way without using any code is to do the following:
    If the "Developer" tab is visible in the menu at the top, in the 'Controls' group, click the 'Design Mode' button. (If the "Developer" tab is not visible, make it visible. A quick Google search will give you instructions if you don't know how to make it visible.) The button will change color to indicate that 'Design Mode' is active. Macros are disabled in 'Design Mode'. Next save your file as the name of the master file. After saving, simply click the 'Design Mode' button again to enable the macros. You can use this method at any time using the 'Design Mode' button as an 'On/Off' switch.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Registered User
    Join Date
    03-08-2018
    Location
    Derbyshire, England
    MS-Off Ver
    Excel 2016, Office 365
    Posts
    33

    Re: Force Save As for master file for other users

    Thank you! That works great - I'd no idea you could do that. It'll make life a lot easier!

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,821

    Re: Force Save As for master file for other users

    You are very welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 10-21-2012, 06:00 PM
  2. One Master file to create different-2 file according to master file & save to computer
    By sonu_kumar444 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-22-2012, 06:13 AM
  3. One Master file to create different-2 file according to master file & save to computer
    By sonu_kumar444 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-21-2012, 10:59 AM
  4. force save as only if activeworkbook name matches master
    By smalltime06 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-27-2012, 11:30 PM
  5. VBA code to allow users to work on the copy of master file.
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-19-2010, 10:41 AM
  6. Force save as file type
    By wilro85 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2008, 02:02 PM
  7. Force user to save file with specified filename
    By jen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2006, 08:50 PM
  8. Force Save over existing file
    By XCESIV in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-25-2006, 03:55 AM

Tags for this Thread

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