With the push from a button on one of my FoxPro forms
using the Excel automation (object model), I create an
employee listing on a spreadsheet that will be sent to a
client. I protect the sheet so that the client cannot edit
the listing, but I want them to be able to add a NEW entry
(employee) into the listing if needed. So, in the VFP code
that's creating the spreadsheet, I want to add a button
that will:

-Unprotect the spreadsheet
-Insert a new row and "unlock" that row
-Protect the spreadsheet again with the password

I think I know how to add a button to the spreadsheet
through my code, but I don't know how to add the 'Click'
event code for the button from within my VFP code.

I've read the 'MS Office Automation with VFP' book and it
doesn't help.

This has to be entirely automated (no actual Excel
interaction).

Please help...any examples (VBA or VFP code) would be
welcome.