Hi,

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,

Ed

You can use the SaveAs method to enable a password