Reply
 
LinkBack Thread Tools Display Modes
  #1   Report Post  
Old April 3rd 08, 09:59 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2008
Posts: 3
Default How do I activate right mouse button in Excel

The dropdown on the right mouse button suddenly disappeared. It works with
all other programs except Excel. I opened an Excel file that contains major
Visual Basic Programming. When I closed it, the scroll bars were missing and
it EXcel was set to full screen view. I managed to get all of it back by
cahnging it in Options, but now I don't have a dropdown on the right mouse
button.

  #2   Report Post  
Old April 4th 08, 12:33 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,909
Default How do I activate right mouse button in Excel

Sounds like code disabled the Cell right-click menu and other stuff<g

Run this macro.

Sub reset()
Application.CommandBars("Cell").Enabled = True
End Sub

How about if you right-click on a sheet tab?

If sheet tab r-click is also disabled you need

Sub reset()
Application.CommandBars("Plyl").Enabled = True
End Sub


Gord Dibben MS Excel MVP

On Thu, 3 Apr 2008 01:59:02 -0700, Gerhard
wrote:

The dropdown on the right mouse button suddenly disappeared. It works with
all other programs except Excel. I opened an Excel file that contains major
Visual Basic Programming. When I closed it, the scroll bars were missing and
it EXcel was set to full screen view. I managed to get all of it back by
cahnging it in Options, but now I don't have a dropdown on the right mouse
button.


  #3   Report Post  
Old April 4th 08, 02:28 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2007
Posts: 897
Default How do I activate right mouse button in Excel

<gasp What kind of code removes the scrollbars and rghtclick menu
then doesn't clean itself up after exiting??

--JP

On Apr 3, 7:33*pm, Gord Dibben <gorddibbATshawDOTca wrote:
Sounds like code disabled the Cell right-click menu and other stuff<g

Run this macro.

Sub reset()
* * Application.CommandBars("Cell").Enabled = True
End Sub

How about if you right-click on a sheet tab?

If sheet tab r-click is also disabled you need

Sub reset()
* * Application.CommandBars("Plyl").Enabled = True
End Sub

Gord Dibben *MS Excel MVP

On Thu, 3 Apr 2008 01:59:02 -0700, Gerhard
wrote:



The dropdown on the right mouse button suddenly disappeared. *It works with
all other programs except Excel. *I opened an Excel file that contains major
Visual Basic Programming. *When I closed it, the scroll bars were missing and
it EXcel was set to full screen view. *I managed to get all of it back by
cahnging it in Options, but now I don't have a dropdown on the right mouse
button.- Hide quoted text -


- Show quoted text -


  #4   Report Post  
Old April 4th 08, 04:29 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,909
Default How do I activate right mouse button in Excel

Rhetorical question, I presume<g


Gord

On Thu, 3 Apr 2008 18:28:54 -0700 (PDT), JP wrote:

<gasp What kind of code removes the scrollbars and rghtclick menu
then doesn't clean itself up after exiting??

--JP

On Apr 3, 7:33*pm, Gord Dibben <gorddibbATshawDOTca wrote:
Sounds like code disabled the Cell right-click menu and other stuff<g

Run this macro.

Sub reset()
* * Application.CommandBars("Cell").Enabled = True
End Sub

How about if you right-click on a sheet tab?

If sheet tab r-click is also disabled you need

Sub reset()
* * Application.CommandBars("Plyl").Enabled = True
End Sub

Gord Dibben *MS Excel MVP

On Thu, 3 Apr 2008 01:59:02 -0700, Gerhard
wrote:



The dropdown on the right mouse button suddenly disappeared. *It works with
all other programs except Excel. *I opened an Excel file that contains major
Visual Basic Programming. *When I closed it, the scroll bars were missing and
it EXcel was set to full screen view. *I managed to get all of it back by
cahnging it in Options, but now I don't have a dropdown on the right mouse
button.- Hide quoted text -


- Show quoted text -


  #5   Report Post  
Old April 4th 08, 11:51 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2007
Posts: 897
Default How do I activate right mouse button in Excel

Absolutely!


--JP

On Apr 3, 11:29*pm, Gord Dibben <gorddibbATshawDOTca wrote:
Rhetorical question, I presume<g

Gord



On Thu, 3 Apr 2008 18:28:54 -0700 (PDT), JP wrote:
<gasp What kind of code removes the scrollbars and rghtclick menu
then doesn't clean itself up after exiting??


--JP



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel 2007 cant use scrolling mouse button Darius Excel Discussion (Misc queries) 2 May 3rd 07 02:53 AM
How to activate drop down box using keystrokes not mouse Lesliec4000 Excel Worksheet Functions 4 January 26th 07 09:19 PM
Hyperlink in cells....how to activate it with out a mouse homer Excel Discussion (Misc queries) 0 November 22nd 06 01:10 AM
How do I activate the right mouse click in Excel? Kcm Excel Discussion (Misc queries) 0 March 28th 06 08:14 AM
moving mouse highlights cells without touching left mouse button bremboy Excel Discussion (Misc queries) 2 January 27th 05 06:19 PM


All times are GMT +1. The time now is 11:59 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017