I have a work book with multiple sheets. I want the user to be able to
select sheet 1 to access macro buttons. I want them to be able to view the
results of the macro data entries on sheet 2, but I do not want them to be
able to directly modify or even select sheet 2, only view the entered data.

I can't simply protect the worksheet, because new data is being added and
old data changed.

I tried changing the worksheet properties in VBA, EnableSelection to "No
Selection", but that did not seem to have an effect.

Help? Is this possible?

-Bill