Forum Discussion

s_p_venugopal's avatar
s_p_venugopal
Copper Contributor
Apr 25, 2020

Sheet Tab settings

Dear Sir,   I am unable to move or copy or delete the sheet by using right click of the Mouse. I t is possible to do through Keyboard.   Please provide the solution to do the same through Right c...
excel
gyankosh's avatar
gyankosh
Brass Contributor
Apr 25, 2020

Try this

Press Alt+F11

it'll take you  to the visual basic.

Now type this ctrl+G it'll focus you to immediate window. Type this and press Enter

application.commandbars("Cells").reset

 PRESS ENTER. Try after that

 

s_p_venugopal 

  • s_p_venugopal's avatar
    s_p_venugopal
    Copper Contributor
    Apr 26, 2020

    gyankosh 

     

    I have gone through the procedure given by you. Getting the error, as given below.

    Run-time error '5'

    Invalid procedure call or argument

     

    Please advise further.

    • gyankosh's avatar
      gyankosh
      Brass Contributor
      Apr 26, 2020

      cell not cells. I typed yesterday so got the wrong spelling.

      application.CommandBars("cell").Reset

      It won't cause the error.

      Try this

       

      s_p_venugopal 

Resources