Unwanted Password upon Workbook_Open Event

Hi All,

I adapted some code found here:

HTML Code: 

for a neat solution that forces users to enable macros. This method is a really good way of getting around this problem. However, my additional requirements are: one particular user needs a more sensitive version of 2 sheets within the workbook. Depending on the answer to a MsgBox an InputBox requires password verification and then shows the sensitive versions of these sheets.
I believe the answer lies in how the workbook is saved and then how all sheets are unhidden upon re-opening the workbook (since two of the sheets are effectively password locked) but somehow now when I open this workbook the password used for unhiding the two sensitive versions of the sheets is required to open the workbook.
So I changed the password required for verification of the said sheets but the Original password is still required to open the workbook:
Please help!!

Please Login or Register  to view this content.

Bump. Any ideas folks?