Hello ALL

I Have written a Macro which opens a dialog and
ask user to enter some data. After recving the
data, I enter this data to the sheet.

Now How do i restrict user to enter only data
thru my dialog. Since if user tries to modify
or delete the data dierctly from the xls sheet,
it will be a problem. Can we protect the sheet?

When user enter the data in the dialog, we will
remove the protection and once he closes the dialog
we will enable the protection. Can v do this?

Thanks In Advance

Reg