+ Reply to Thread
Results 1 to 2 of 2

Adding Windows Authentication to my Autosave function to Save Workbook in protected locati

  1. #1
    Registered User
    Join Date
    11-14-2017
    Location
    Seattle
    MS-Off Ver
    2010
    Posts
    1

    Adding Windows Authentication to my Autosave function to Save Workbook in protected locati

    I have an autosave script currently that works great, but I am pretty sure I need to use windows authentication to have this vba code autosave my workbook in a protected file folder. (We don't want anyone to accidentally delete it.) I had my IT department create a service account with a never expiring password just for this purpose, but I have no idea how to add windows authentication code to my vba.

    I was looking at the code here:
    https://www.experts-exchange.com/que...using-VBA.html

    But I do not understand how to properly implement it.

    My current save script is:

    Please Login or Register  to view this content.

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Adding Windows Authentication to my Autosave function to Save Workbook in protected lo

    Hi,

    That code wouldn't help you unless the workbook is being run using the service account- is that the case?

    Is there a reason you don't simply allow access to the relevant users? Then they will only be able to save the workbook if they are logged in correctly anyway.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ 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. Save Specific Protected Sheets to a new Workbook
    By aprilapple04 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2016, 02:48 PM
  2. Replies: 1
    Last Post: 05-28-2016, 01:59 PM
  3. export a workbook to a password protected zip file, using the default windows zip program
    By Alina Loredana in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2016, 08:32 AM
  4. Adding Folder to 'Open' and 'Save As' windows
    By Philanalyst in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-16-2009, 10:19 AM
  5. [SOLVED] Save As Authentication Issue From ASP.NET
    By Matt Schwartz in forum Excel General
    Replies: 0
    Last Post: 06-09-2006, 12:40 AM
  6. Opened Autosave but when closing workbook Autosave closes itself
    By Ken in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-29-2005, 01:05 PM
  7. WHERE IS AUTOSAVE ON WINDOWS XL 2003?
    By vicki in forum Excel General
    Replies: 3
    Last Post: 09-13-2005, 07:05 PM

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