peacenik
03-31-2008, 07:47 PM
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?
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?