Locking the use of Macros from other Workbooks

Originally Posted by Maudise

sorry, I'm on excel 2010 have just updated that aspect.

I've locked the VBA project for viewing using a secure password, my problem largely resides in the fact that you can open a blank excel workbook, then open my document and run a simple

sub Unhide_Sheets()
Sheets(1).visible = xlsheetvisible
Sheets(2).visible = xlsheetvisible
Sheets(3).visible = xlsheetvisible
end sub

And by running that macro when my document is selected it'll unhide the sheets.

Thanks
Maudise

I think you'll find that there is no way to completely stop someone from accessing sheets and code as you've just pointed out. The only saving grace is that most people that use Excel or other Office products, haven't got a clue regarding how to actually hack a workbook.