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

Can you please share a sample workbook displaying the problem?

That would be a start, however might not be enough. Can you produce a desensitised copy and share that?

Is the workbook being saved as .xlsx at any point instead of .xlsm?

Are you really still using Excel 2007?

Hi sorry I know it would make it easier but I wouldn't feel comfortable even producing a desensitised copy unless it was a last resort.

Please Login or Register  to view this content.

Haha well I use 2007 at home and 2010 at work.

The work book is saved as both a .xlsm and a .xlsx at the same time in two locations however it was doing the "active content error" before I started saving it as a .xlsx as well.

Could it just be that the admin's at my work have made it so that it automatically disabled active content?

I think the admins at work need speaking to first - you need to eliminate that before trying to troubleshoot any further.

By the way, your thread title is a bit vague - can you please make it a bit more detailed? Thanks.

In answer to your latest question - possibly. Make that part of your improved thread title. You'll have to wait for a VBA expert. Most people aren't up at this time on a Saturday!

EDIT: Title MUCH better - thanks.