ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Problem with IE menus after installing excel macros (https://www.excelbanter.com/excel-programming/304261-problem-ie-menus-after-installing-excel-macros.html)

Michael Moyna

Problem with IE menus after installing excel macros
 
I have created a excel Macro, that formats a predefined
csv file. The macro loads and works ok in Excel, however if you open the csv
file with in the Microsoft Internet Explorer (IE 6.0) parts of the IE menu
becomes inactive. Nothing happens when you select the Edit, View, Insert,
Format, Tools, and Data edit menu options however the File, goto, Favorites
and help menu options are working OK. This is strange as it works on a few
computers with the exact same software and patches installed.



I would be grateful if somebody could point me in the right direction to
resolve the problem.

Thanks

Michael



Dave Peterson[_3_]

Problem with IE menus after installing excel macros
 
Any chance that the users are opening the .csv file in excel proper--not excel
embedded within MSIE?

From a previous post:

There's a setting in Windows that you can change.

In win98, I can do this:
Start Windows Explorer
View|Folder Options
File Types Tab
scroll down to MS Excel Worksheet
Select it
click the edit button
There's an option to "browse in same window". Uncheck it.

That's where you can toggle the "confirm open after download", too.

How to Configure Internet Explorer to Open Office
Documents in the Appropriate Office Program Instead of in Internet Explorer
http://support.microsoft.com/?scid=162059



Michael Moyna wrote:

I have created a excel Macro, that formats a predefined
csv file. The macro loads and works ok in Excel, however if you open the csv
file with in the Microsoft Internet Explorer (IE 6.0) parts of the IE menu
becomes inactive. Nothing happens when you select the Edit, View, Insert,
Format, Tools, and Data edit menu options however the File, goto, Favorites
and help menu options are working OK. This is strange as it works on a few
computers with the exact same software and patches installed.

I would be grateful if somebody could point me in the right direction to
resolve the problem.

Thanks

Michael


--

Dave Peterson



All times are GMT +1. The time now is 10:29 AM.

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