Hello there,

I have a application written in Visual Basic 6.0 that manipulates the contents with MS Excel. I have set the visible property of the application to false and have created a new instance of the application through code. However, when a new spreadsheet is opened by an user when the application is running, the workbook used by the program (VB) is opened and disallows the user editing content in MS Excel. I have also kept the application.interaction = false.

Thanks in advance

Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Hi,

Ill also answer here

Try setting Application.UserControl = True