Formatting the excel window
Hi,
I am opening an excel file within a windows form. I want the user to only play around with the excel area. The user should not create or open an excel file. So I want to hide the menu bar and disable the New and Open standard toolbar buttons. I use the following C# code to achieve my goal:
// xlApp is the instance of Excel.Application
xlApp.WindowState = Excel.
XlWindowState.xlMaximized;// Hide the Menu barint counter = xlApp.ActiveWindow.Application.CommandBars.Count;for (int i = 1; i <= counter; i++){
try{
string nm = xlApp.ActiveWindow.Application.CommandBars[i].Name;if (nm =="Standard"){
int count_control = xlApp.ActiveWindow.Application.CommandBars[i].Controls.Count;for (int j = 1; j <= 2; j++){
xlApp.ActiveWindow.Application.CommandBars[i].Controls[j].Enabled =
false;}
}
if (nm =="Worksheet Menu Bar"){
xlApp.ActiveWindow.Application.CommandBars[i].Enabled =
false;}
}
catch (Exception ex){
MessageBox.Show(ex.ToString());}
}
// Show the necessary command barsxlApp.CommandBars[
"Standard"].Visible =true;xlApp.CommandBars[
"Standard"].Position = Office.MsoBarPosition.msoBarTop;xlApp.CommandBars[
"Visual Basic"].Visible =true;xlApp.CommandBars[
"Visual Basic"].Position = Office.MsoBarPosition.msoBarTop;xlApp.CommandBars[
"Formatting"].Visible =true;xlApp.CommandBars[
"Formatting"].Position = Office.MsoBarPosition.msoBarTop;The problem now is that at times this code works fine and I see only the necessary buttons and toolbars but at times I dont see any toolbar button. Can somebody please explain this strange behaviour? Is there a standard code to hide/show excel buttons/toolbars?
(I am using C# with Office 2000)
Regards,
Asim.
