Excel worksheet object

  • Thread starter Thread starter Derek
  • Start date Start date
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
 
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.
 
Back
Top