How to restric another excel app to attach to the created applicat

  • Thread starter Thread starter Alamelu
  • Start date Start date
A

Alamelu

I am creating excel in my application using create dispatch, when my
application is running i dont want another excel application to attach to my
existing application

How to restric another excel application to attach to the application
created by my project
 
Please try and feedback

With Application
.ScreenUpdating = False
.EnableEvents = False
End With

If this post helps click Yes
 
This doesnt work, this makes my excel worksheet invisible.

My app creates a.xls in the background
Suppose user clicks b.xls, both a.xls and b.xls are getting opened.

b.xls is getting attached to a.xls , that is the problem.
 
Could you please post the code so as to check.

If you have referred the workbook as ActiveWorkbook.Activesheet.... please
change that to Workbooks("Book1").Sheets("Sheet1")....

If this post helps click Yes
 
Back
Top