Active content error allowing unauthorised access to sheets

Hi I've set up my document to always load up a certain sheet and then the user has to enable macro's and enter a password to access any of the other sheets. However for some reason I sometime get "Some active content has been disabled" which allows the user to go on any sheet without having to put any password in??

Is there anyway to stop this?

Cheers