Excel worksheet object

D

Derek

Hello, is it possible to insert an Excel worksheet into an Access form and
make it editable on the form itself. I know how to insert the Excel
worksheet object into the form, but the only way I'm able to edit it is to
open the actual Excel file itself. Is there a way to make it editable on
the form instead?

Thanks,
Derek
 
F

fredg

Hello, is it possible to insert an Excel worksheet into an Access form and
make it editable on the form itself. I know how to insert the Excel
worksheet object into the form, but the only way I'm able to edit it is to
open the actual Excel file itself. Is there a way to make it editable on
the form instead?

Thanks,
Derek
Click to expand...

If you use an OLEUnbound control, set it's Locked property to No and
it's Enabled property to Yes.
Set it's AutoActivate property to Double-click.

Double-clicking on the control opens spreadsheet for editing.
Best i can do for you.
 
Top