OLE

D

Dan

Hello there,
I have an Excel sheet (OLE object in the table) on a form , I have setup
the Property in "Auto Activate" as Double-Click , so when I double click the
object the sheet open.

But sometime the object appears on the form as an Excel Icon - then when I
double click it open in Excel - that is what I want.
But sometime it appears as a table of data and when I double click it open
on the form - I want to avoid that and instead always have the sheet open in
excel.

Any idea?
Many many thanks,
Dan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working outlook via vba code with xlsx - error 0
Set as Default Template not working 0
Excel sheet (OLE object) sometimes open on the form sometimes in E 1
Shortcuts in OneDrive 0
Need Help with Macro Security 1
Excel does not accept text format! 0
365 office launcher error 6
How to open multiple instances of Word 365? 5

Top