Right Click Function

[Mollie]

The right click function does not work in Excel. However,
it works just fine in all other applications. What am I
missing?

 

[David McRitchie]

Hi Mollie,

What does the right-click not work on, you probably had
a macro or addin fail. Think of what you were last working with
before you had your problem. If you had been working with
macros, I'd give the following a shot.

Sub Fix_Things()
Application.Commandbars("Ply").Enabled = True 'Rclick on WS Tab
Application.DisplayAlerts = True
Application.EnableEvents = True 'WS Events
End Sub

 

[Chip Pearson]

Just adding to David's code, I would enable the "Cell" menu, too.

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

Hi Mollie,

What does the right-click not work on, you probably had
a macro or addin fail. Think of what you were last working with
before you had your problem. If you had been working with
macros, I'd give the following a shot.

Sub Fix_Things()
Application.Commandbars("Ply").Enabled = True 'Rclick on WS Tab
Application.DisplayAlerts = True
Application.EnableEvents = True 'WS Events
End Sub

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

The right click function does not work in Excel. However,
it works just fine in all other applications. What am I
missing?

 

[Mollie]

The right click has never worked when it comes to
highlighting cells to copy, paste, format, etc.

-----Original Message-----
Hi Mollie,

What does the right-click not work on, you probably had
a macro or addin fail. Think of what you were last working with
before you had your problem. If you had been working with
macros, I'd give the following a shot.

Sub Fix_Things()
Application.Commandbars("Ply").Enabled = True 'Rclick on WS Tab
Application.DisplayAlerts = True
Application.EnableEvents = True 'WS Events
End Sub

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

The right click function does not work in Excel. However,
it works just fine in all other applications. What am I
missing?

.

 

[Gord Dibben]

Mollie

The right-click in Excel was not designed to highlight cells. You must
highlight cells using the left-click then hit right-click to get a menu.

Gord Dibben Excel MVP - XL97 SR2 & XL2002

The right click has never worked when it comes to
highlighting cells to copy, paste, format, etc.

-----Original Message-----
Hi Mollie,

What does the right-click not work on, you probably had
a macro or addin fail. Think of what you were last working with
before you had your problem. If you had been working with
macros, I'd give the following a shot.

Sub Fix_Things()
Application.Commandbars("Ply").Enabled = True 'Rclick on WS Tab
Application.DisplayAlerts = True
Application.EnableEvents = True 'WS Events
End Sub

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

The right click function does not work in Excel. However,
it works just fine in all other applications. What am I
missing?

.

 

[stephens]

Mollie

The right-click in Excel was not designed to highlight cells. You must
highlight cells using the left-click then hit right-click to get a menu.

I actually DOES work for a single cell.

Gord Dibben Excel MVP - XL97 SR2 & XL2002

The right click has never worked when it comes to
highlighting cells to copy, paste, format, etc.

-----Original Message-----
Hi Mollie,

What does the right-click not work on, you probably had
a macro or addin fail. Think of what you were last working with
before you had your problem. If you had been working with
macros, I'd give the following a shot.

Sub Fix_Things()
Application.Commandbars("Ply").Enabled = True 'Rclick on WS Tab
Application.DisplayAlerts = True
Application.EnableEvents = True 'WS Events
End Sub

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

The right click function does not work in Excel. However,
it works just fine in all other applications. What am I
missing?


.