Solved: Locking down a spreadsheet

[peacenik]

I have a spreadsheet that I am distributing to many people that I want to lock down. I know that the security on Excel VBA is not that strong, but I would like to do as much as I can.

I thought I had it locked down pretty well using vba script and the Visible property, but discovered a remarkably simple way to get around that, despite password security on the VBA part of the spreadsheet.

I am trying to be circumspect because I don't want to make it easy for people to break security, but what I want to know is if it possible to prevent the objects in a spreadsheet being controlled from other VBA code?

[Jan Karel Pieterse]

You could lock both the sheet and the objects. To be honest I've never tried if you can change locked object props on a locked sheet though.

[peacenik]

The objects that I am able to change are the worksheets. They are already protected, but Visibility is not controlled by the Protection.

[Jan Karel Pieterse]

Protect the structure of your workbook.

[peacenik]

Thanks. It was as simple as that.