No password asked when using VBA to protect Sheet

Originally Posted by royUK

AFAIK a password set in VBA will still prompt for a password when manually unprotecting the sheet.

Hi royUK,

For some strange reason it is not prompting me when I manually unprotect the sheet. I thought the same as you that when you protect a sheet in VBA Excel should still prompt you for a password when unprotecting a sheet manually.

I've never come across this, maybe you can attach your workbook.

Hi royUK,

I have done a test sheet with the exact code that I have used. I hope you can figure it out.

I manually set the password as "pw" in the tools menu, you will also see this in the code in Module1 when it unprotects and then re-protects the worksheet.

I hope you can figure this out for me.

Thanks.

I gat a prompt for the password using your workbook.

Originally Posted by royUK

I gat a prompt for the password using your workbook.

I get a prompt only if I unprotect the sheet without using the VBA code.

However if I use the 'CTRL+SHIFT+S' to which if you look at it unprotects the sheet and then once the code runs in protects the sheet again. However once you now unprotect the sheet via the Tool menu the prompt does not pop up.

I have now confirmed this on my home pc as well as my work pc. Did you run the code with the shortcut key?

I did use the short cut.

Originally Posted by royUK

I did use the short cut.

This is really strange, I can't understand why the prompt does not come up for me once I run the code.

I have the 'Analysis ToolPak' installed but I wouldn't have thought that would interfere with the password system.