Context Menu (Sub-Menu Disable/Enable)
By right clicking on a cell I get a context menu where I can choose Insert...
or Delete... Each of these choices produces a sub-menu: Shift cells right, Shift cells left, Insert Entire Row, Insert Entire Column. The Delete option has the same sub-menu except it is for the delete option. I know how to disable or make invisible an option: Application.CommandBars("cell").Controls("Insert.. .").Visible = False Application.CommandBars("cell").Controls("Insert.. .").Enable = False My question is how do I disable or make invisible only a sub-menu item such as "Insert Entire Row"? |
Context Menu (Sub-Menu Disable/Enable)
I don't think there's anything to add to the answer given by Ron de Bruin to
the same question you posted a couple of days ago. Regards, Peter T "JR_06062005" wrote in message ... By right clicking on a cell I get a context menu where I can choose Insert... or Delete... Each of these choices produces a sub-menu: Shift cells right, Shift cells left, Insert Entire Row, Insert Entire Column. The Delete option has the same sub-menu except it is for the delete option. I know how to disable or make invisible an option: Application.CommandBars("cell").Controls("Insert.. .").Visible = False Application.CommandBars("cell").Controls("Insert.. .").Enable = False My question is how do I disable or make invisible only a sub-menu item such as "Insert Entire Row"? |
Context Menu (Sub-Menu Disable/Enable)
It's true I did ask the same question a couple of days ago under the title
"Disable Sub-Menu of a Context Menu", but my screen does not show that anyone responded to the question. Are you sure Ron's answer was to my question? Like I said, on my screen, there is no answer to my first posting. If you have any ideas how I can view Ron's answer, I would appreciate it. "Peter T" wrote: I don't think there's anything to add to the answer given by Ron de Bruin to the same question you posted a couple of days ago. Regards, Peter T "JR_06062005" wrote in message ... By right clicking on a cell I get a context menu where I can choose Insert... or Delete... Each of these choices produces a sub-menu: Shift cells right, Shift cells left, Insert Entire Row, Insert Entire Column. The Delete option has the same sub-menu except it is for the delete option. I know how to disable or make invisible an option: Application.CommandBars("cell").Controls("Insert.. .").Visible = False Application.CommandBars("cell").Controls("Insert.. .").Enable = False My question is how do I disable or make invisible only a sub-menu item such as "Insert Entire Row"? |
Context Menu (Sub-Menu Disable/Enable)
The ng is archived in Gougle Groups
http://tinyurl.com/jsvm7 Regards, Peter T "JR_06062005" wrote in message ... It's true I did ask the same question a couple of days ago under the title "Disable Sub-Menu of a Context Menu", but my screen does not show that anyone responded to the question. Are you sure Ron's answer was to my question? Like I said, on my screen, there is no answer to my first posting. If you have any ideas how I can view Ron's answer, I would appreciate it. "Peter T" wrote: I don't think there's anything to add to the answer given by Ron de Bruin to the same question you posted a couple of days ago. Regards, Peter T "JR_06062005" wrote in message ... By right clicking on a cell I get a context menu where I can choose Insert... or Delete... Each of these choices produces a sub-menu: Shift cells right, Shift cells left, Insert Entire Row, Insert Entire Column. The Delete option has the same sub-menu except it is for the delete option. I know how to disable or make invisible an option: Application.CommandBars("cell").Controls("Insert.. .").Visible = False Application.CommandBars("cell").Controls("Insert.. .").Enable = False My question is how do I disable or make invisible only a sub-menu item such as "Insert Entire Row"? |
Context Menu (Sub-Menu Disable/Enable)
Impressive url! Thanks.
"Peter T" wrote: The ng is archived in Gougle Groups http://tinyurl.com/jsvm7 Regards, Peter T "JR_06062005" wrote in message ... It's true I did ask the same question a couple of days ago under the title "Disable Sub-Menu of a Context Menu", but my screen does not show that anyone responded to the question. Are you sure Ron's answer was to my question? Like I said, on my screen, there is no answer to my first posting. If you have any ideas how I can view Ron's answer, I would appreciate it. "Peter T" wrote: I don't think there's anything to add to the answer given by Ron de Bruin to the same question you posted a couple of days ago. Regards, Peter T "JR_06062005" wrote in message ... By right clicking on a cell I get a context menu where I can choose Insert... or Delete... Each of these choices produces a sub-menu: Shift cells right, Shift cells left, Insert Entire Row, Insert Entire Column. The Delete option has the same sub-menu except it is for the delete option. I know how to disable or make invisible an option: Application.CommandBars("cell").Controls("Insert.. .").Visible = False Application.CommandBars("cell").Controls("Insert.. .").Enable = False My question is how do I disable or make invisible only a sub-menu item such as "Insert Entire Row"? |
All times are GMT +1. The time now is 11:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com