I have a template with forms...data in the forms is fed from the excel sheet....in workbook open event i have the "form.show". I put this template on the intranet and almost 100 people tested it opening through browser...it worked fine for 90% but just handful of systems have the problem. All have windows XP.

Problem : when user opens the template from the browser...instead of showing the formit shows the excel sheet...but the form is open. To get to the form you have to alt+tab......

does someone have any idea/hint what could it be...and what to try to find out the bug....

Suggestions will be appreciated.

Thanks,
--
Ajit

Hi Ajit;

Try setting the focus for the form programatically instead
or relying on thier OS to implicitly do it.

Thanks,

Greg


-----Original Message-----
I have a template with forms...data in the forms is fed
from the excel sheet....in workbook open event i have
the "form.show". I put this template on the intranet and
almost 100 people tested it opening through browser...it
worked fine for 90% but just handful of systems have the
problem. All have windows XP.

Problem : when user opens the template from the
browser...instead of showing the formit shows the excel
sheet...but the form is open. To get to the form you have
to alt+tab......

does someone have any idea/hint what could it be...and
what to try to find out the bug....

Suggestions will be appreciated.

Thanks,
--
Ajit
.

Greg, Thanks for your reply...but unfortunately that didn't work...and i digged some deep and it looks that none of the excel functionality is working...for example i tried doing [msgbox range("A1").value] on worksheet open...and it gave me error "Runtime error 1004" Method "Range of object" failed......I have no idea why it happens and i also tried the same thing in somany other systems and it is perfect......
--
Ajit


"Gjones" wrote:

Hi Ajit;

Try setting the focus for the form programatically instead
or relying on thier OS to implicitly do it.

Thanks,

Greg


-----Original Message-----
I have a template with forms...data in the forms is fed
from the excel sheet....in workbook open event i have
the "form.show". I put this template on the intranet and
almost 100 people tested it opening through browser...it
worked fine for 90% but just handful of systems have the
problem. All have windows XP.

Problem : when user opens the template from the
browser...instead of showing the formit shows the excel
sheet...but the form is open. To get to the form you have
to alt+tab......

does someone have any idea/hint what could it be...and
what to try to find out the bug....

Suggestions will be appreciated.

Thanks,
--
Ajit
.