Excel.Application.Interactive not working in windows7

[Rayner]

Excel.Application.Interactive = False, prevents excel from accessing it. But this property is not working in windows7.


In XP, open excel VBA. Try the following code snippet in a button click,


Excel.Application.WindowState = xlMinimized
Excel.Application.Interactive = False


This will minimize the excel and will never allow excel to maximize even if we click the excel taskbar.
The same code is not working in windows 7.
Is there any alternative for this property which will work in both windows 7 and XP.

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/excel-questions/655739-how-stop-interaction-excel.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: Forum Rules).