I have several Excel VBA documents that are sometimes automated and sometimes not, so they check the app.visible property to determine whether to display a message box. this works fine, except these documents will often be opened in internet explorer where the excelapp.visible property is always false. I've tried using excelapp.activewindow.visible, but it returns true and causes the msgbox to pop up even when the app is not visible. Is there a good way to solve this problem?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel app.visible property in IE
- Thread starter Rodiggy
- Start date
Similar threads
- Locked
- Solved
- Locked
- Question
- Locked
- Question
