Option of Column, line don't appear

  • Thread starter Thread starter Daniel Utsch
  • Start date Start date
D

Daniel Utsch

When I select a column, line or spreadsheet, and I click with the right
button of the mouse, it doesn't appear for me those options of copying, to
past, to insert, to format, etc.... ,and it is for any file and I have Excel
2007. Does anybody know how I get to enable this option again?

Thanks a lot for any help
 
Daniel

Has this been a problem right from the start or did it happen after a period
of time?

Maybe some code disabled the right-click?

In the Immediate Window of the VBE

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


Gord Dibben MS Excel MVP
 
Thanks for your Help. I got to enabled the option of the row and column with
the
command line that you gave me. But I not to get enabled the options of the
right-click in the sheets. What command I have to use?

Sorry for my english, I to learn yet.

"Gord Dibben" escreveu:
 
Strange that the rows and columns commands would be enabled and not the
cells right-click.

Try this...........

Application.CommandBars("Cell").Reset


Gord
 
I have this options in CELL, but I not to get this options in the Sheets, how
to insert the new sheet or move the sheets. I not got this options too in the
commands Button or other object of the commands. I don't know what command I
must do.

"Gord Dibben" escreveu:
 
In 2003 for the sheet tabs commands.............

Application.CommandBars("Ply").Reset

or

Application.CommandBars("Ply").Enabled = True

I don't work with 2007 so don't know about the Commands..............I think
that is part of the Ribbon or QAT......yes?....no?

Some 2007 user will have to jump in here, please.



Gord
 
Hi Gord,

Thanks a Lot for your Help. I got to enable almost everything, but still
lack the option of the Commands Button and buttons of forms. There is any
command for enable the Right click for this objects?

"Gord Dibben" escreveu:
 
You sure the Command Buttons are from the Forms Toolbar?

If from the Control Toolbox you must be in design mode to get a right-click
option.


Gord
 
Back
Top