Excel macro and passwords

Excel Discussion in 'Microsoft Office' started by Frank Woolrich, Nov 14, 2017.

  1. Frank Woolrich

    Frank Woolrich

    Joined:
    Nov 14, 2017
    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
    #1
    1. Advertisements

  2. Frank Woolrich

    JEAN L in Florida

    Joined:
    Nov 15, 2017
    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
    #2
    1. Advertisements

  3. Frank Woolrich

    Frank Woolrich

    Joined:
    Nov 14, 2017
    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
    #3
  4. Frank Woolrich

    Frank Woolrich

    Joined:
    Nov 14, 2017
    Likes Received:
    1
    I did respond to your question on the thread you started asking about this issue of yours I hope it helped.
     
    Frank Woolrich, Nov 20, 2017
    #4
    1. Advertisements

Ask a Question

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.