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"?

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"?

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"?

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"?

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"?