Passwords in macros

Hello,

I am trying to make a macro to hide certain tabs in a workbook and then protect the workbook. Then another macro to unprotect workbook and unhide pages. I get the macro to work but it does not prompt a box to enter password, it just automatically protects or unprotects and I need it to prompt for password first. Any suggestions would be helpful.

Thanks!