Consulting

Results 1 to 3 of 3

Thread: VBA novice needing help!!

  1. #1
    Banned VBAX Newbie
    Joined
    Sep 2018
    Location
    Chesterfield, Derbyshire
    Posts
    1
    Location

    VBA novice needing help!!

    Good morning everyone, I am new here and in desperate need of some advice.
    I know very little about vba etc. so I apologise now for my ignorance!
    I have posted a similar question on MrExcel and another similar site but struggling to comprehend hat I need to do... so anyway...

    I have a master excel spreadsheet that will (eventually) be fed by almost 20 other workbooks that will be password protected.
    How can I write a code on the master spreadsheet that will allow the passwords from the other sheets to be input rather than receive 20 password boxes?!

    Thanks in advance
    Iain

  2. #2
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    3,970
    Location
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    3,970
    Location
    Now also cross-posted at: https://www.ozgrid.com/forum/forum/h...vant-workbooks

    Evidently, you have no regard for this or any other board's rules. Account terminated.
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

Posting Permissions

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