Excel macro and passwords

Excel Discussion in 'Microsoft Office' started by Frank Woolrich, Nov 14, 2017 at 9:46 AM.

  1. Frank Woolrich

    Frank Woolrich

    Joined:
    Tuesday
    Likes Received:
    1
    Hi there I am trying to develop an excel form and need to pull data from another sheet that is password protected, I know the password but don't want the user of the form to know the password, I can't get it to work, I did this but it is wrong I know. any help would be great.

    Sub Refresh_Data()
    '
    ' Refresh_Data Macro
    '
    ' Keyboard Shortcut: Ctrl+Shift+R
    '
    ActiveWorkbook.UpdateLink Name:= _
    "M:\Planner 2017-18\Staff Rota 2017-18.xlsx", Type:=xlExcelLinks
    End Sub

    Say the password is "planner"
     
    Frank Woolrich, Nov 14, 2017 at 9:46 AM
    #1
    1. Advertisements

  2. Frank Woolrich

    JEAN L in Florida

    Joined:
    Wednesday
    Likes Received:
    0
    I have previously been able to rename the sheet and use it.
    Could I ask a question here? I am making my own planner and need to know how to center the sheet?
    How many pixels on a page and how can I change that to inches? Thanks for any help.
     
    JEAN L in Florida, Nov 15, 2017 at 3:01 PM
    #2
    1. Advertisements

  3. Frank Woolrich

    Frank Woolrich

    Joined:
    Tuesday
    Likes Received:
    1
    The idea of my project is for us managers to be able to change a schedule on one planner that is password protected and for another file to be able to pull the data for another user. so that they can see what data we want them to see within another file, I have the data being pulled across, but it asks for the original file's password to pull the data from. We don't want to give the users the password, we just want them to be able to see the data.
     
    Frank Woolrich, Nov 15, 2017 at 3:12 PM
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. troylook

    Outlook Outlook PST Files Require Passwords After Running SCANPST.EXE

    troylook, Dec 18, 2007, in forum: Microsoft Office
    Replies:
    0
    Views:
    835
    troylook
    Dec 18, 2007
  2. AxilD
    Replies:
    1
    Views:
    1,425
    SlimJim
    Jan 17, 2008
  3. Chuck101
    Replies:
    0
    Views:
    673
    Chuck101
    Mar 3, 2008
  4. PeteFC

    Excel Excel 2007:Toolbars and Macro Problem

    PeteFC, Jan 15, 2010, in forum: Microsoft Office
    Replies:
    3
    Views:
    748
    PeteFC
    Feb 19, 2010
  5. JKL

    Excel Excel Macro Validation List and Print Help

    JKL, Jul 27, 2010, in forum: Microsoft Office
    Replies:
    0
    Views:
    809
  6. DJL_DASH

    Excel Excel Macro to Create a Drop Down List and Hide Cells

    DJL_DASH, Jul 8, 2011, in forum: Microsoft Office
    Replies:
    2
    Views:
    2,669
    DJL_DASH
    Jul 12, 2011
  7. fiebuls
    Replies:
    3
    Views:
    1,203
    Stoneboysteve
    Jan 6, 2012
  8. Johnnyspa
    Replies:
    2
    Views:
    1,124
    Johnnyspa
    Oct 30, 2012
Loading...