+ Reply to Thread
Results 1 to 5 of 5

when I right click on a excel worksheet, I do not get the dropdow.

  1. #1
    Nbhatt
    Guest

    when I right click on a excel worksheet, I do not get the dropdow.

    Has anyone had a problem with displaying the dropdown menu containing
    Edit|Paste|etc in the worksheet. I have a user who has this problem. I have
    remove and re-installed Office to no avail.

  2. #2
    Bob Phillips
    Guest

    Re: when I right click on a excel worksheet, I do not get the dropdow.

    Maybe you have some code disabling it.

    Try entering

    Application.Commandbars("Cell").Visible = True

    on the VBIDE immediate window (Ctrl-G). If that brings it back, search for
    some similar code in your start-up workbooks.

    --
    HTH

    Bob Phillips

    "Nbhatt" <[email protected]> wrote in message
    news:[email protected]...
    > Has anyone had a problem with displaying the dropdown menu containing
    > Edit|Paste|etc in the worksheet. I have a user who has this problem. I

    have
    > remove and re-installed Office to no avail.




  3. #3
    Norman Jones
    Guest

    Re: when I right click on a excel worksheet, I do not get the dropdow.


    Hi Bob,

    I think you have a small typo

    > Application.Commandbars("Cell").Visible = True


    should be:

    Application.Commandbars("Cell").Enabled


    --
    Regards,
    Norman



    "Bob Phillips" <[email protected]> wrote in message
    news:[email protected]...
    > Maybe you have some code disabling it.
    >
    > Try entering
    >
    > Application.Commandbars("Cell").Visible = True
    >
    > on the VBIDE immediate window (Ctrl-G). If that brings it back, search for
    > some similar code in your start-up workbooks.
    >
    > --
    > HTH
    >
    > Bob Phillips
    >
    > "Nbhatt" <[email protected]> wrote in message
    > news:[email protected]...
    >> Has anyone had a problem with displaying the dropdown menu containing
    >> Edit|Paste|etc in the worksheet. I have a user who has this problem. I

    > have
    >> remove and re-installed Office to no avail.

    >
    >




  4. #4
    Norman Jones
    Guest

    Re: when I right click on a excel worksheet, I do not get the dropdow.

    And just to prove that typos are contagious:

    > Application.Commandbars("Cell").Enabled


    S/be

    Application.Commandbars("Cell").Enabled =True

    ---
    Regards,
    Norman



    "Norman Jones" <[email protected]> wrote in message
    news:[email protected]...
    >
    > Hi Bob,
    >
    > I think you have a small typo
    >
    >> Application.Commandbars("Cell").Visible = True

    >
    > should be:
    >
    > Application.Commandbars("Cell").Enabled
    >
    >
    > --
    > Regards,
    > Norman
    >
    >
    >
    > "Bob Phillips" <[email protected]> wrote in message
    > news:[email protected]...
    >> Maybe you have some code disabling it.
    >>
    >> Try entering
    >>
    >> Application.Commandbars("Cell").Visible = True
    >>
    >> on the VBIDE immediate window (Ctrl-G). If that brings it back, search
    >> for
    >> some similar code in your start-up workbooks.
    >>
    >> --
    >> HTH
    >>
    >> Bob Phillips
    >>
    >> "Nbhatt" <[email protected]> wrote in message
    >> news:[email protected]...
    >>> Has anyone had a problem with displaying the dropdown menu containing
    >>> Edit|Paste|etc in the worksheet. I have a user who has this problem. I

    >> have
    >>> remove and re-installed Office to no avail.

    >>
    >>

    >
    >




  5. #5
    Bob Phillips
    Guest

    Re: when I right click on a excel worksheet, I do not get the dropdow.

    Thanks Norman, too many options with the differing CBs ;-(

    Bob

    "Norman Jones" <[email protected]> wrote in message
    news:%23C%[email protected]...
    > And just to prove that typos are contagious:
    >
    > > Application.Commandbars("Cell").Enabled

    >
    > S/be
    >
    > Application.Commandbars("Cell").Enabled =True
    >
    > ---
    > Regards,
    > Norman
    >
    >
    >
    > "Norman Jones" <[email protected]> wrote in message
    > news:[email protected]...
    > >
    > > Hi Bob,
    > >
    > > I think you have a small typo
    > >
    > >> Application.Commandbars("Cell").Visible = True

    > >
    > > should be:
    > >
    > > Application.Commandbars("Cell").Enabled
    > >
    > >
    > > --
    > > Regards,
    > > Norman
    > >
    > >
    > >
    > > "Bob Phillips" <[email protected]> wrote in message
    > > news:[email protected]...
    > >> Maybe you have some code disabling it.
    > >>
    > >> Try entering
    > >>
    > >> Application.Commandbars("Cell").Visible = True
    > >>
    > >> on the VBIDE immediate window (Ctrl-G). If that brings it back, search
    > >> for
    > >> some similar code in your start-up workbooks.
    > >>
    > >> --
    > >> HTH
    > >>
    > >> Bob Phillips
    > >>
    > >> "Nbhatt" <[email protected]> wrote in message
    > >> news:[email protected]...
    > >>> Has anyone had a problem with displaying the dropdown menu containing
    > >>> Edit|Paste|etc in the worksheet. I have a user who has this problem. I
    > >> have
    > >>> remove and re-installed Office to no avail.
    > >>
    > >>

    > >
    > >

    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1