Page 1 of 2 12 LastLast
Results 1 to 15 of 25
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Australia
    Posts
    245
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi - I have not been back for quite some time to the new Lounge and it is quite impressive.

    However I find the search facility brings up too many (irrelevant) results. Therefore I would like some advice on VBA code for changing the password (sheets) in a folder. In my example there are approximately 6000 workbooks and the number of sheets varies between five and nine.

    Thanks for any responses or suggestions, Leigh

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Australia
    Posts
    245
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi - I have not been back for quite some time to the new Lounge and it is quite impressive.

    However I find the search facility brings up too many (irrelevant) results. Therefore I would like some advice on VBA code for changing the password (sheets) in a folder. In my example there are approximately 6000 workbooks and the number of sheets varies between five and nine.

    Thanks for any responses or suggestions, Leigh

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Australia
    Posts
    245
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi - I have not been back for quite some time to the new Lounge and it is quite impressive.

    However I find the search facility brings up too many (irrelevant) results. Therefore I would like some advice on VBA code for changing the password (sheets) in a folder. In my example there are approximately 6000 workbooks and the number of sheets varies between five and nine.

    Thanks for any responses or suggestions, Leigh

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Australia
    Posts
    245
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi - I have not been back for quite some time to the new Lounge and it is quite impressive.

    However I find the search facility brings up too many (irrelevant) results. Therefore I would like some advice on VBA code for changing the password (sheets) in a folder. In my example there are approximately 6000 workbooks and the number of sheets varies between five and nine.

    Thanks for any responses or suggestions, Leigh

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Australia
    Posts
    245
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi - I have not been back for quite some time to the new Lounge and it is quite impressive.

    However I find the search facility brings up too many (irrelevant) results. Therefore I would like some advice on VBA code for changing the password (sheets) in a folder. In my example there are approximately 6000 workbooks and the number of sheets varies between five and nine.

    Thanks for any responses or suggestions, Leigh

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Australia
    Posts
    245
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi - I have not been back for quite some time to the new Lounge and it is quite impressive.

    However I find the search facility brings up too many (irrelevant) results. Therefore I would like some advice on VBA code for changing the password (sheets) in a folder. In my example there are approximately 6000 workbooks and the number of sheets varies between five and nine.

    Thanks for any responses or suggestions, Leigh

  7. #7
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Australia
    Posts
    245
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi - I have not been back for quite some time to the new Lounge and it is quite impressive.

    However I find the search facility brings up too many (irrelevant) results. Therefore I would like some advice on VBA code for changing the password (sheets) in a folder. In my example there are approximately 6000 workbooks and the number of sheets varies between five and nine.

    Thanks for any responses or suggestions, Leigh

  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Australia
    Posts
    245
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi - I have not been back for quite some time to the new Lounge and it is quite impressive.

    However I find the search facility brings up too many (irrelevant) results. Therefore I would like some advice on VBA code for changing the password (sheets) in a folder. In my example there are approximately 6000 workbooks and the number of sheets varies between five and nine.

    Thanks for any responses or suggestions, Leigh

  9. #9
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    So you want to loop through the 6000 workbooks (are they all in the same folder?)
    Opening each in turn and looping through each individual workbook, protecting each sheet with a password.
    The same password for each sheet in every book?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  10. #10
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    So you want to loop through the 6000 workbooks (are they all in the same folder?)
    Opening each in turn and looping through each individual workbook, protecting each sheet with a password.
    The same password for each sheet in every book?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  11. #11
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    So you want to loop through the 6000 workbooks (are they all in the same folder?)
    Opening each in turn and looping through each individual workbook, protecting each sheet with a password.
    The same password for each sheet in every book?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  12. #12
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    So you want to loop through the 6000 workbooks (are they all in the same folder?)
    Opening each in turn and looping through each individual workbook, protecting each sheet with a password.
    The same password for each sheet in every book?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  13. #13
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    So you want to loop through the 6000 workbooks (are they all in the same folder?)
    Opening each in turn and looping through each individual workbook, protecting each sheet with a password.
    The same password for each sheet in every book?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  14. #14
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    So you want to loop through the 6000 workbooks (are they all in the same folder?)
    Opening each in turn and looping through each individual workbook, protecting each sheet with a password.
    The same password for each sheet in every book?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  15. #15
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    So you want to loop through the 6000 workbooks (are they all in the same folder?)
    Opening each in turn and looping through each individual workbook, protecting each sheet with a password.
    The same password for each sheet in every book?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Page 1 of 2 12 LastLast

Posting Permissions

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