Edit commands not available

[Eric Young]

I have Excel 2003, SP3 on a laptop. For some time now, the "Cut" "Copy"
"Paste" "Paste Special" commands that I use often are grayed out (not
available). How do I solve this problem?

 

[Tausif]

Can you do a few checks?

1) Tools->Protection->Unproctect(worksheet & workbook)
2) Making sure the workbook is not shared (Tools, Share Workbook..., remove
checkmark from allow multiple users)

3) If that doesnt work, could you plz try this ?
a) Open Excel
b) Press Alt+F11 (to open the vbe)
c) Insert -> Module (enter the lines below in the module)
Sub EnableTB()
With CommandBars(1).Controls("Edit")
.Controls("Copy").Enabled = True
.Controls("Paste").Enabled = True
.Controls("Paste Special...").Enabled = True
End With
End Sub
Press F5 to execute the code. (Make sure the curson is placed in the
procedure )

HTH,

 

[Eric Young]

1. The Tools, Protection command was gray.
2. The Tools, Share Workbook command was gray.
3. After selecting Insert Module in Microsoft Visual Basic, I entered the
commands exactly as shown below. When executing the routine with the F5
command I received

Run-time error "5":
Invalid procedure call or argument

I chose "Debug" and it highlighted the "Paste Special" line. I did not find
anything entered differently than shown below.

What next?

 

[Tausif]

Hi Eric,

The line shld be ".Controls("Paste Special...").Enabled = True "
I just tried it out, it worked fine for me. Are you using Excel 2003 ?

Atleast is the Copy & Paste command working for you now ?

Cheers,

 

[Eric Young]

It seems I can now copy & paste, but not paste special. A survey of all the
menu commands that are gray returns the following:
File - Save, Save as, Save as Web Page, Save Workspace, Sent to, Properties.
Edit - Can't Repeat, Cut, Paste Special, Paste as Hyperlink, Delete Sheet,
Move or Copy Sheet, Links, Object.
Insert - Worksheet.
Tools - Compare & Merge Worksheet, Protection, Macro.
Data - Refresh Data.
Window - Compare Side by Side With, Unhide

The Version is Excel 2003 (11.8211.8202) SP3

Thanks for your interest.

 

[Rahul Movva]

I tried the above solutions and it did not work any other options?

 

[Carrie]

I am having this same problem and the code did nothing. Have you had any
luck with a fix Rahul?