prevent new workbooks from opening in avtive workbook

[mkalenuik]

Hi, I was wondering is one the the VB experts out there can tell me if there is a way with vb to prevent another workbook from opening in the same window. What I have is an excel application that i want to keep separete from other workbooks that might get opened. For instance when this workbook open it needs to be the only one in the application. If another xls file is opened it needs to open in a new application widow. Is this possible?

[romperstomper]

In the workbook's ThisWorkbook module:

Please Login or Register  to view this content.

[mkalenuik]

Thanks a lot works great

[romperstomper]

Glad to help.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save