No menu when right-clicking

E

Ewa

Hi!
When I right click on a selected area in Excel 2000, the
area gets copied instead of showing me the ordinary right-
click-menu (where you can for example do inserts etc). I
don´t know anything about programming and I wonder if I
can solve this by just using the buttons and menus in
Excel? (The menu that I´m missing when right-clicking is
the one you get if you press Shift+F10). Can anyone help
me out?

Big thanks!

Ewa.
 
P

papou

Hello
Since you don't know much about programming here's a step by step procedure
to reset your commandbar using a macro:
Tools, Macro, New Macro, click Yes
Immediately after :Tools, Macro, Stop recording
Tools, Macro, Macros, select Macro1 and click on Modify
On the next screen will appear something looking this:
Sub Macro1()
'
'Macro1 Macro
'Macro recorded 09/24/2004 by ...
'

'
End Sub

Modify the Macro so that it becomes:
Sub Macro4()
'
' Macro4 Macro
' Macro enregistrée le 24/09/2004 par ROBIN Pascal
'
Application.CommandBars("Cell").Reset
'
End Sub

Close the VB Editor
Run Macro1 and check and see if your right-click popups again.

If this does not solve your problem I am afraid you will have to rename the
..XLB file on your system (this file contains notably information about the
Excel tool bars)
HTH
Cordially
Pascal


"Ewa" <[email protected]> a écrit dans le message de
Hi!
When I right click on a selected area in Excel 2000, the
area gets copied instead of showing me the ordinary right-
click-menu (where you can for example do inserts etc). I
don´t know anything about programming and I wonder if I
can solve this by just using the buttons and menus in
Excel? (The menu that I´m missing when right-clicking is
the one you get if you press Shift+F10). Can anyone help
me out?

Big thanks!

Ewa.
 
Top