Results 1 to 4 of 4

Thread: Disable Password Prompt
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2018
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Disable Password Prompt

    Follow up from a (very) old post:

    https://www.mrexcel.com/forum/excel-...readsheet.html

    I wondered if someone could advise if its possible to de-activate the password prompt. I have a macro in place to link all the sheets to my master sheet - but the request for the passwords still appears.

    I can click cancel on the boxes - however if there is a way to not have to do this that would be perfect!

    Thanks
    Iain
    0 0
     

  2. #2
    Board Regular Ramballah's Avatar
    Join Date
    Sep 2018
    Location
    Netherlands
    Posts
    176
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Disable Password Prompt

    Quote Originally Posted by Iain McBride View Post
    Sorry for the confusion - I have all the passwords but want to not have to spend the time entering all 12 on my master spreadsheet.

    Thanks
    So basically you want something like a button you press on your main sheet that unlocks all the other sheets?
    0 0
     

  3. #3
    New Member
    Join Date
    Aug 2018
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Disable Password Prompt

    I have a VBA Macro with all the passwords - but the prompt to manually insert all the passwords still appears - and ideally I don't want this to appear (as its very annoying lol)
    Last edited by Iain McBride; Oct 2nd, 2018 at 08:18 AM.
    0 0
     

  4. #4
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,815
    Post Thanks / Like
    Mentioned
    48 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Disable Password Prompt

    This appears to be basically a duplicate of a question you have posted before, and one that you have cross-posted in several forums withouth providing links, in spite of previous requests. This thread is therefore being closed, and I suggest you start complying with the rules if you wish to keep your posting privileges. Thank you.
    0 0
     

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •