Switchboard in Excel. Password to hide and unhide sheets. User form hangs

Hi,

I'm testing out an application where a use of a switchboard is preferred because there are 3 sites.

There are few issues I'm tackling:

1) when users open the workbook, they can still see the contents of different worksheets until they manually enable macro. This is not desired.
2) When the user form pops up, (Main Page), if user from A clicks on button "A", it will bring up an inputbox for password, which is desired. However, if the right password is supplied by user, the program hangs there until user clicks on the "x" mark to cancel out of the "Main Page". This is not desired.

The code for accessing A is:

Please Login or Register  to view this content.

The code for hiding the sensitive sheets are:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

How do I get around this easily? Password is "A" for this test application.

Can anyone point me in the right direction please?

Thanks

Delete the on close macro and replace it with this.

Please Login or Register  to view this content.

And it does not hang for me after changing the code BTW.