| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting "Arrange Side by Side with..." command from Window menuba
Good afternoon,
Can anyone suggest why I can delete all the other commands from the Windows menu bar, apart from this one. I just want to be able to display the list of currently open workbooks, but don't seem to be able to get rid of this command. The syntax I'm using is: cbMainMenuBar.Controls("Window").Controls("Compare Side by Side with...").Delete Thanks in advance Pete |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deleting "Arrange Side by Side with..." command from Window menuba
If there is only one window, then this menu choice is disabled. So perhaps
this is the source of your problem. -- Regards, Tom Ogilvy "Peter Rooney" wrote in message ... Good afternoon, Can anyone suggest why I can delete all the other commands from the Windows menu bar, apart from this one. I just want to be able to display the list of currently open workbooks, but don't seem to be able to get rid of this command. The syntax I'm using is: cbMainMenuBar.Controls("Window").Controls("Compare Side by Side with...").Delete Thanks in advance Pete |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deleting "Arrange Side by Side with..." command from Window me
Tom,
It's there, but it's greyed out - I would like to remove it altogether. Cheers Pete "Tom Ogilvy" wrote: If there is only one window, then this menu choice is disabled. So perhaps this is the source of your problem. -- Regards, Tom Ogilvy "Peter Rooney" wrote in message ... Good afternoon, Can anyone suggest why I can delete all the other commands from the Windows menu bar, apart from this one. I just want to be able to display the list of currently open workbooks, but don't seem to be able to get rid of this command. The syntax I'm using is: cbMainMenuBar.Controls("Window").Controls("Compare Side by Side with...").Delete Thanks in advance Pete |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deleting "Arrange Side by Side with..." command from Window me
try opening a second workbook (so two are opened) so it is not grayed. Then
see if you can delete it. -- Regards, Tom Ogilvy "Peter Rooney" wrote in message ... Tom, It's there, but it's greyed out - I would like to remove it altogether. Cheers Pete "Tom Ogilvy" wrote: If there is only one window, then this menu choice is disabled. So perhaps this is the source of your problem. -- Regards, Tom Ogilvy "Peter Rooney" wrote in message ... Good afternoon, Can anyone suggest why I can delete all the other commands from the Windows menu bar, apart from this one. I just want to be able to display the list of currently open workbooks, but don't seem to be able to get rid of this command. The syntax I'm using is: cbMainMenuBar.Controls("Window").Controls("Compare Side by Side with...").Delete Thanks in advance Pete |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deleting "Arrange Side by Side with..." command from Window me
Tom,
No, I can't. Pete "Tom Ogilvy" wrote: try opening a second workbook (so two are opened) so it is not grayed. Then see if you can delete it. -- Regards, Tom Ogilvy "Peter Rooney" wrote in message ... Tom, It's there, but it's greyed out - I would like to remove it altogether. Cheers Pete "Tom Ogilvy" wrote: If there is only one window, then this menu choice is disabled. So perhaps this is the source of your problem. -- Regards, Tom Ogilvy "Peter Rooney" wrote in message ... Good afternoon, Can anyone suggest why I can delete all the other commands from the Windows menu bar, apart from this one. I just want to be able to display the list of currently open workbooks, but don't seem to be able to get rid of this command. The syntax I'm using is: cbMainMenuBar.Controls("Window").Controls("Compare Side by Side with...").Delete Thanks in advance Pete |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deleting "Arrange Side by Side with..." command from Window me
Is this working for you
Sub test() Dim Ctl As CommandBarControl For Each Ctl In Application.CommandBars("Worksheet Menu Bar").FindControl(ID:=30009).Controls On Error Resume Next 'Ctl.Enabled = False Ctl.Delete On Error GoTo 0 Next Ctl End Sub Sub test2() Application.CommandBars("Worksheet Menu Bar").FindControl(ID:=30009).Reset End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Peter Rooney" wrote in message ... Tom, No, I can't. Pete "Tom Ogilvy" wrote: try opening a second workbook (so two are opened) so it is not grayed. Then see if you can delete it. -- Regards, Tom Ogilvy "Peter Rooney" wrote in message ... Tom, It's there, but it's greyed out - I would like to remove it altogether. Cheers Pete "Tom Ogilvy" wrote: If there is only one window, then this menu choice is disabled. So perhaps this is the source of your problem. -- Regards, Tom Ogilvy "Peter Rooney" wrote in message ... Good afternoon, Can anyone suggest why I can delete all the other commands from the Windows menu bar, apart from this one. I just want to be able to display the list of currently open workbooks, but don't seem to be able to get rid of this command. The syntax I'm using is: cbMainMenuBar.Controls("Window").Controls("Compare Side by Side with...").Delete Thanks in advance Pete |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deleting "Arrange Side by Side with..." command from Window me
Ron,
Absolutely superb! Thanks a lot. I don't suppose you know where there's a definitive list of those IDs and the controls that they apply to, is there? Do the IDs change for different versions of Excel? Thanks VERY much Pete "Ron de Bruin" wrote: Is this working for you Sub test() Dim Ctl As CommandBarControl For Each Ctl In Application.CommandBars("Worksheet Menu Bar").FindControl(ID:=30009).Controls On Error Resume Next 'Ctl.Enabled = False Ctl.Delete On Error GoTo 0 Next Ctl End Sub Sub test2() Application.CommandBars("Worksheet Menu Bar").FindControl(ID:=30009).Reset End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Peter Rooney" wrote in message ... Tom, No, I can't. Pete "Tom Ogilvy" wrote: try opening a second workbook (so two are opened) so it is not grayed. Then see if you can delete it. -- Regards, Tom Ogilvy "Peter Rooney" wrote in message ... Tom, It's there, but it's greyed out - I would like to remove it altogether. Cheers Pete "Tom Ogilvy" wrote: If there is only one window, then this menu choice is disabled. So perhaps this is the source of your problem. -- Regards, Tom Ogilvy "Peter Rooney" wrote in message ... Good afternoon, Can anyone suggest why I can delete all the other commands from the Windows menu bar, apart from this one. I just want to be able to display the list of currently open workbooks, but don't seem to be able to get rid of this command. The syntax I'm using is: cbMainMenuBar.Controls("Window").Controls("Compare Side by Side with...").Delete Thanks in advance Pete |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deleting "Arrange Side by Side with..." command from Window me
Hi Peter
See my page about this (also the KB's on the bottom) http://www.rondebruin.com/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Peter Rooney" wrote in message ... Ron, Absolutely superb! Thanks a lot. I don't suppose you know where there's a definitive list of those IDs and the controls that they apply to, is there? Do the IDs change for different versions of Excel? Thanks VERY much Pete "Ron de Bruin" wrote: Is this working for you Sub test() Dim Ctl As CommandBarControl For Each Ctl In Application.CommandBars("Worksheet Menu Bar").FindControl(ID:=30009).Controls On Error Resume Next 'Ctl.Enabled = False Ctl.Delete On Error GoTo 0 Next Ctl End Sub Sub test2() Application.CommandBars("Worksheet Menu Bar").FindControl(ID:=30009).Reset End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Peter Rooney" wrote in message ... Tom, No, I can't. Pete "Tom Ogilvy" wrote: try opening a second workbook (so two are opened) so it is not grayed. Then see if you can delete it. -- Regards, Tom Ogilvy "Peter Rooney" wrote in message ... Tom, It's there, but it's greyed out - I would like to remove it altogether. Cheers Pete "Tom Ogilvy" wrote: If there is only one window, then this menu choice is disabled. So perhaps this is the source of your problem. -- Regards, Tom Ogilvy "Peter Rooney" wrote in message ... Good afternoon, Can anyone suggest why I can delete all the other commands from the Windows menu bar, apart from this one. I just want to be able to display the list of currently open workbooks, but don't seem to be able to get rid of this command. The syntax I'm using is: cbMainMenuBar.Controls("Window").Controls("Compare Side by Side with...").Delete Thanks in advance Pete |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Turn on "View Side by Side" option | Excel Discussion (Misc queries) | |||
| Can you freeze one side of the Excel window so the other side stay | Excel Discussion (Misc queries) | |||
| "View side by side" on Excel? | Excel Discussion (Misc queries) | |||
| Excel 2007 "view side by Side" | Excel Discussion (Misc queries) | |||
| "Compare Side by Side" in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
