I have a xla that produces a menu in excel. When the user selects an option
from the menu, it opens another xla and shows a form.
Currently the form is displayed but then closes straight away.

As anyone seen this issue before.

(Windows XP, and Office 2003).

Cheers
--
Paicey

an xla is an add-in. Put the form into your Personal.xls or just convert it
to xls. Code it to be opened as ReadOnly.



"Paicey" wrote:

I have a xla that produces a menu in excel. When the user selects an option
from the menu, it opens another xla and shows a form.
Currently the form is displayed but then closes straight away.

As anyone seen this issue before.

(Windows XP, and Office 2003).

Cheers
--
Paicey

Using the two add-ins worked fine until I upgraded to Office 2003.
I use the add-in's as I don't want the users to know that a different
document has been opened.

--
Paicey


"exceluserforeman" wrote:

an xla is an add-in. Put the form into your Personal.xls or just convert it
to xls. Code it to be opened as ReadOnly.



"Paicey" wrote:

I have a xla that produces a menu in excel. When the user selects an option
from the menu, it opens another xla and shows a form.
Currently the form is displayed but then closes straight away.

As anyone seen this issue before.

(Windows XP, and Office 2003).

Cheers
--
Paicey

I really do not know and am only guessing but did you start excel from
excel.exe ?
If your shortcuts do not point to Excel.exe then the current
directory/folder will not be the file you opened.
Best to open your first file from within Excel ... File Open method.

Also see if the add-in is check marked. also, I think Office 2003 will only
accept digitally signed add-ins. This just means you have to fill in the
properties of the addin.

- -Mark
"Paicey" wrote:

Using the two add-ins worked fine until I upgraded to Office 2003.
I use the add-in's as I don't want the users to know that a different
document has been opened.

--
Paicey


"exceluserforeman" wrote:

an xla is an add-in. Put the form into your Personal.xls or just convert it
to xls. Code it to be opened as ReadOnly.



"Paicey" wrote:

I have a xla that produces a menu in excel. When the user selects an option
from the menu, it opens another xla and shows a form.
Currently the form is displayed but then closes straight away.

As anyone seen this issue before.

(Windows XP, and Office 2003).

Cheers
--
Paicey