Results 1 to 12 of 12

Help neded! Password restricting/protecting copy file!

Threaded View

dgavranovic Help neded! Password... 02-26-2014, 12:18 PM
tony h Re: Help neded! Password... 02-26-2014, 04:01 PM
timmatthews Re: Help neded! Password... 02-26-2014, 04:04 PM
dgavranovic Re: Help neded! Password... 02-26-2014, 04:39 PM
timmatthews Re: Help neded! Password... 02-26-2014, 04:44 PM
timmatthews Re: Help neded! Password... 02-26-2014, 04:52 PM
dgavranovic Re: Help neded! Password... 02-26-2014, 04:58 PM
tony h Re: Help neded! Password... 02-26-2014, 05:14 PM
dgavranovic Re: Help neded! Password... 02-27-2014, 12:48 PM
tony h Re: Help neded! Password... 02-27-2014, 01:17 PM
timmatthews Re: Help neded! Password... 02-27-2014, 01:43 PM
dgavranovic Re: Help neded! Password... 02-27-2014, 05:03 PM
  1. #11
    Registered User
    Join Date
    11-06-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Help neded! Password restricting/protecting copy file!

    i think if im reading right you want the new file to be password protected so you can't open it without the password? try this.
    ActiveSheet.Copy
        NewFN = "S:\Respiratory_Therapy\Team\Dalibor\ShiftReport" & Range("J2").Value & ".xlsx"
        ActiveWorkbook.SaveAs NewFN, FileFormat:=xlOpenXMLWorkbook, Password:="password"
        ActiveWorkbook.Close
        Dim NextShiftReport
    Last edited by timmatthews; 02-27-2014 at 01:44 PM. Reason: remove unneeded line of code

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Password protecting 7-zip file
    By DanzaNZ in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-17-2015, 03:48 AM
  2. Protecting and Reading password from text file
    By rkayasth in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-26-2010, 08:09 PM
  3. VBA for password protecting file
    By dhrestak in forum Word Programming / VBA / Macros
    Replies: 8
    Last Post: 07-12-2010, 10:12 AM
  4. Password Protecting cells in shared file
    By robmharrison in forum Excel General
    Replies: 2
    Last Post: 10-17-2008, 11:45 AM
  5. [SOLVED] Password protecting certain worksheets in a file
    By Mike in forum Excel General
    Replies: 1
    Last Post: 03-29-2005, 11:06 PM

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