mouse trouble in excel

T

tatertatum

I use excel 2003 at work and when I try to right click on a cell to get the
copy paste menu nothing happens in any cell. I checked it in work and it
works fine as well as in diffrent programs we use. It only fails to work in
excel is there a option that has been disabled?
 
F

FC

Hi, I could think of 2 things so far.
1- Either the workbook or worksheet is protected or
2- You have "Excel Viewer" at work that will not allow you to do nothing but
view and print.
Try tool>protection>unprotect for the first option.
For the second, you'll have to install regular excel, not viewer.
 
T

tatertatum

we have full copys of office including full excel not viewer and second im
working with a new workbook and I have not protected it. i can go to edit and
click copy and paste it just wont open the menu when I right click in a cell.
 
J

Jim Thomlinson

Right click is a menu that can be disabled via code. It is a persistent
setting so once set it can only be reversed via code... Right click on a
sheet tab and select view code. Paste the following code. Run the code with
the play button...

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