Hi all,

i have a workbook and i want to run a macro to unprotect the workbook by prompting for a password first.

Now if i want to prompt the user for a password and then unprotect the SHEET then using the following is fine:

ActiveSheet.Unprotect
However when i use:

ActiveWorkbook.Unprotect
i get an runtime error that the password supplied is incorrect (even though i haven't supplied one).

Does anyone know how to get a password prompt there?

Thanks

James