Greyed out "Cut", "Copy", "Paste" and "Paste Special" in Excel

[Jules48]

I hope someone can help me here. Ever since trying some VBA code posted elsewhere on this forum, my "Cut", "Copy", "Paste" and "Paste Special" options are permanently greyed out both in the "Edit" menu and in the mouse right-click menu of Excel.

This happens with every Excel file I open and even with new files created after a fresh boot.

Interestingly, if I log on as a different user all seems to be fine.

I can't see any VBA code or macros anywhere at all and I wonder whether something in the registry could have been changed.

I'm running Excel 2000 on XP Professional SR2.

The code I tried, just in a "test" file (which was deleted afterwards) was that found at:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=373

I really hope someone can help me out here as this is driving me completely crazy. :banghead:

Thanks,

Jules

[Jacob Hilderbrand]

Run this macro:


Option Explicit

Sub ResetCommandBars()

Dim CBar As CommandBar

For Each CBar In Application.CommandBars
CBar.Reset
Next

Set CBar = Nothing

End Sub



Does it resolve the problem?

[Jules48]

Excellent DRJ.
That seems to have done the trick.
Thanks very much.

:hi:

Jules

[Jacob Hilderbrand]

You're Welcome :beerchug:

Take Care