ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel VB Script Not Working in Explorer (https://www.excelbanter.com/excel-programming/298754-excel-vbulletin-script-not-working-explorer.html)

Carrie[_3_]

Excel VB Script Not Working in Explorer
 
Good Evening,

I was hoping someone would have an answer to a problem I'm
having. I created an Excel spreadsheet that has a load
event procedure that is a series of input boxes and
forms. This spreadsheet was posted on our intranet site
site. It works fine when I open it on my computer, but
when I try using other people's computers either the
script is totally eliminated or the boxes come up slowly
without the spreadsheet showing until the last box has
been filled in. I'm thinking that this may be a browser
security issue, but I'm not sure how to fix it. I realize
that we can bypass the entire issue by asking the user to
save the file onto one of their drives, but I would prefer
them to have the ability to use the document directly from
their browser if at all possible. Any suggestions?

Thanks,

Carrie

Harlan Grove[_5_]

Excel VB Script Not Working in Explorer
 
"Carrie" wrote...
I was hoping someone would have an answer to a problem I'm
having. I created an Excel spreadsheet that has a load
event procedure that is a series of input boxes and
forms. This spreadsheet was posted on our intranet site
site. It works fine when I open it on my computer, but
when I try using other people's computers either the
script is totally eliminated or the boxes come up slowly
without the spreadsheet showing until the last box has
been filled in. I'm thinking that this may be a browser
security issue, but I'm not sure how to fix it. I realize
that we can bypass the entire issue by asking the user to
save the file onto one of their drives, but I would prefer
them to have the ability to use the document directly from
their browser if at all possible. Any suggestions?


If they can use the document within IE as an Excel workbook, then your users
must have Excel on their systems. IE itself isn't programmed to be an Office
substitute on its own. Since your users would have Office on their systems, you
could configure IE to launch Excel workbooks and other Office documents in their
proper Office app.

http://support.microsoft.com/?id=162059

--
To top-post is human, to bottom-post and snip is sublime.

Carrie[_3_]

Excel VB Script Not Working in Explorer
 
Thanks. That works

Carrie


All times are GMT +1. The time now is 07:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com