I have something odd going on here. I have a sheet that has a button on it to which I've assigned a macro. The button's properties are set to Locked and Lock Text.

Upon opening the worksheet containing this sheet, I have the following snippet run:
Please Login or Register  to view this content.
When that runs, it locks everything just fine ... except the button. I can right click on it and assign a different macro, as if nothing happened.

Now, if I manually unlock the sheet, and manually re-lock it, suddenly the button is locked and I can no longer change the macro (which is what I want to do in the first place.) However, by doing it manually, I loose the UserInterfaceOnly attribute. And this needs to be done automatically anyway, not manually.

Is there something I'm missing?