MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Use IE to open Excel Chart


Posted by Lyvia Chung on August 01, 2001 12:32 AM

Dear Sir,

I'd like to use IE to open excel file which is chart.
But when I open it, there is toolbar call "chart" will display in the middle of screen.

How to disable it??
Thanks for your helping.

BR,

Lyvia Chung



Posted by Rob Jackson on August 01, 2001 12:51 AM

This is the vb command if that helps.
Application.CommandBars("Chart").Visible = False


Posted by lyiva chung on August 01, 2001 2:42 AM

I have tried it. But not work.
Have any other idea??


Posted by Rob Jackson on August 01, 2001 7:09 AM

Sorry Lyvia,
This is how I would switch it off on Excel Visual Basic. Where are you writing your code? What is IE?

R.


Posted by lyiva chung on August 01, 2001 6:21 PM

Dear Rob,

IE means "internet explorer". I feel strange coz it's ok to switch it off in Excel. But if I use the browser to view it. It will show it on the middle screen. It will be ok if I can put it on top of screen. Do you know how??
Many thanks.

L. Sorry Lyvia,

Posted by RobJackson on August 02, 2001 1:05 AM

Sorry Lyvia,
Don't think I can help you with this one.

Appologies

Rob

Dear Rob, IE means "internet explorer". I feel strange coz it's ok to switch it off in Excel. But if I use the browser to view it. It will show it on the middle screen. It will be ok if I can put it on top of screen. Do you know how??