Excel File through IE

[Mitch_s_s]

Hi,

I am using IE6, excel 2003, SP2

I am making files available via a link on the intranet
I save the file, and when I open it through the intranet link the file opens in IE

the problem I am having is that, there is vba code in the file
and the code bugs, when it is referencing ranges etc.
when I open the file normally through excel there is no errors
it just appears to be when I am opening the file through IE

are there any known issues/fixes that can help me resolve this

please ask if any part of this post is unclear

Thanks
Mitch

[RobDog888]

Its security violations as normal vba code wont be run in a web browser. You need to adjust your setting by perhaps adding the site to your trusted sites collection since this is an intrranet site it should be safe.

[Mitch_s_s]

how would i go about that?

is it hard to do?

potentially 300+ people could view and use this file

everything is locked down in work, so it would be hard for me to arrange any security settings to be changed

the digital certificate will be trusted on these machines

is that not enough?

you know any alternatives, so i can get round this?

thanks

[RobDog888]

Well unless you can remove the vba code you will need some way of allowing it to run.

[Mitch_s_s]

damn

is there no way to open excel instead of opening IE

sorry for all the questions