Force a new instance of excel to open

[paulquinlan100]

Hi

I'm trying to force excel to open a new instance when a user double
clicks on a particular file. This is so that the menus that are
disabled in this file are not also disabled in any other excel
workbooks that they have open.

Looking through older posts someone suggested using:

Application.IgnoreRemoteRequests = False

Ive tried putting this in the Workbook_Open event but the menu changes
are still applied to other open workbooks.

Does anyone know where i'm going wrong?
Thanks for any suggestions.
Paul

 

[Jim Thomlinson]

While what you are trying to do is feasable it is not the best solution for
what you ultimately want to accomplish. If one of your workbook is disabling
menus and toolbars the best solution is to have that workbook handle the
hiding and unhiding based on it being active or not. In this workbbok there
are open close activate and deactivate events which you can use to modify the
toolbars. In this way as the users switches between this workbook and other
workbooks the menues can be syncronized appropriately.

If you still want to follow your original course (which I do not recommend
from experience) here is an easy way to do it.

Create a new workbook that will be your method of getting into the intended
workbook. In the On Open event have the workbook create a new instance of XL.
Open your target workook in the new instance. Close the workbbook that is
running the code.