Hi Bill,

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

If I understand your problem correctly, you actually can protect the sheet,
with the UserInterfaceOnly option, if you are using XL 2000 or later. This
allows you to change the sheet through code, while keeping the sheet
protected. You need to set this property each time the workbook is opened -
it doesn't persist after the workbook is closed.

hth,

Doug


"Bill" wrote in message
...
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