ActiveWorkbook.Unprotect (prompt for password)

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:

Please Login or Register  to view this content.

However when i use:

Please Login or Register  to view this content.

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