Hi,

I have a worksheet "UnprocessedPayments". It is populated with some
unprocessed payment records as some fields (columns) are in error. In
addition to the fields in error, the sheet also has suggested values
to the fields in error.

I have provided the user with two command buttons "UpdateSheet" and
"ProceedTOUpload". The user can either agree with the suggested values
or he can provide his own values in the suggested fields. When the
"UpdateSheet" command button is pressed all the suggested/userchanged
values will overwrite the fields in error. The the user sj=hould press
the "ProceedTOUpload" command button to process the payments.

The above works fine. What I want is that when the user presses the
"ProceedTOUpload" button without pressing "UploadSheet" then the
system should display an error message that the "UpdateSheet" needs to
be pressed.

Also one more question. If we have a command button in a user form and
we click it then it directly goes to the code window into
command_click event. But why does it not happen with a comman button
on a sheet. Also the code page for the sheet has only General and
Worksheet sections. Why doesn't it identify any controls on it. I had
to assign a macro to these command button to work.