Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2001

    Unanswered: getPasswordFromUser Input password in private procedure


    Problem on Excel with VB

    In a manual procedure under VB, I start by unprotecting a worksheet in order to write data in Excel under the procedure and at the end of the procedure I protect the same worksheet.

    BUT, this is not enough.

    I would like to fill automatically the box generated by the function getPasswordFromUser .

    The aim is to for the users of the Excel Workbook not to be able to unprotect the worksheet without password.

    Is there any way to mention the password in the VB procedure?

    Thanks and best regards,


  2. #2
    Join Date
    Feb 2002
    You can use the SaveAs method to enable a password

Posting Permissions

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