Posted to microsoft.public.excel.programming

[email protected] EagleOne@discussions.microsoft.com is offline

external usenet poster

Posts: 391

VBA code line to ascertain if VBAProject(Test) in the IDE is open

2003, 2007

Assume:

a VBA project VBAProject(Test) is listed in IDE

What VBA code line would "sense" (True/False) if and attempt to open VBAProject(Test) is requested?

And/Or if VBAProject(Test) is open in an IDE window?

And/Or if the IDE is open?

TIA EagleOne

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA code to ascertain difference between Range1 and Range2	[email protected]	Excel Programming	6	April 14th 09 02:01 AM
Programmatically Open Locked VBAProject	Michael PE	Excel Programming	5	January 3rd 08 05:22 PM
VBAProject remains open after file is closed	sequoia sam	Excel Discussion (Misc queries)	4	August 2nd 05 07:59 PM
Test for VBAProject Locked from Viewing	DennisE	Excel Programming	2	January 25th 04 09:02 PM
code in VBAProject will not run	Mike[_58_]	Excel Programming	2	November 9th 03 04:08 PM

All times are GMT +1. The time now is 08:27 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us