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

On Sun, 14 Dec 2008 06:56:09 -0800, Daniel Utsch
wrote:

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

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:

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

On Sun, 14 Dec 2008 06:56:09 -0800, Daniel Utsch
wrote:

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

Strange that the rows and columns commands would be enabled and not the
cells right-click.

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

Application.CommandBars("Cell").Reset


Gord

On Sun, 14 Dec 2008 10:40:01 -0800, Daniel Utsch
wrote:

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:

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

On Sun, 14 Dec 2008 06:56:09 -0800, Daniel Utsch
wrote:

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

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:

Strange that the rows and columns commands would be enabled and not the
cells right-click.

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

Application.CommandBars("Cell").Reset


Gord

On Sun, 14 Dec 2008 10:40:01 -0800, Daniel Utsch
wrote:

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:

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

On Sun, 14 Dec 2008 06:56:09 -0800, Daniel Utsch
wrote:

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

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


On Sun, 14 Dec 2008 11:26:07 -0800, Daniel Utsch
wrote:

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:

Strange that the rows and columns commands would be enabled and not the
cells right-click.

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

Application.CommandBars("Cell").Reset


Gord

On Sun, 14 Dec 2008 10:40:01 -0800, Daniel Utsch
wrote:

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:

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

On Sun, 14 Dec 2008 06:56:09 -0800, Daniel Utsch
wrote:

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