I want to check the value of a cell (which, through a VB script is given a value based on a Windows variable), and then affect access to the workbook based on that value.

I can get to the point where the value is either true (displaying a '1'), or false (displaying a '0').

What I want to do, is, if the value is false, render the workbook unusable, or totally uneditable, or unviewable (you get my drift anyway) - I dont mind them seeing whats there, but I dont want them to be able to update any cells.

The worksheet is already password protected, and only about 10 cells are unlocked for editing. I guess locking those 10 cells out from being edited, if the above value is false, would be my ultimate goal.

I understand that anyone capable of unlocking Excel workbooks would get around this in 10 seconds flat, but that is not of a concern to me.