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" <(E-Mail Removed)> wrote in message
news:04502B37-51BE-45EE-ABD5-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:04502B37-51BE-45EE-ABD5-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
news7F4D05F-2A34-4607-9EB7-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> > news:04502B37-51BE-45EE-ABD5-(E-Mail Removed)...
> > > 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" <(E-Mail Removed)> wrote in message
> news7F4D05F-2A34-4607-9EB7-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> > > news:04502B37-51BE-45EE-ABD5-(E-Mail Removed)...
> > > > 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"?
> > > >
> > >
> > >
> > >
>
>
>