Al,

If you attempt to unprotect a password-protected sheet without
supplying the password, Excel will automatically prompt for the
password.

ActiveSheet.Unprotect



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"MrAlMackay" wrote in message
...
Dave

Don't actually want the spreadsheet to be unprotected through
the macro.

I only want to get to the dialog box (@ this point I would need
the macro to
end) as this is when the user would type in the password or
alternatively if it
isn't one of the administrators they would exit out.

Is it possible to get the dialog box through VBA?

Appreciate your help on this.

Many Thanks, Al