Excel Copy and Paste (Greyed)

[TKT-Tang]

1. Open an existing Excel workbook with mulltiple sheets.

2. Activate Sheet1 ; Right-click the mouse short-cut menu (which shows
Copy okay, but Paste and Paste Special are greyed).

3. That means that Paste operation is hampered on Sheet1.

4. However, the right-click mouse's short-cut menu is apparently
working okay on the other worksheets (meaning that Paste and Paste
Special are not greyed thereof).

5. Please share your comment ; What could be done to restore the
Copy-and-Paste operations on the right-click mouse's short-cut menu for
Sheet1 ?

6. Regards.

 

[prabhuraaman]

I don't see a direct way.
Sometimes a macro may be written so as to delete the contents of the
keyboard
Check if any code is written in the activate event of sheet1

Try copy paste in the same worksheet.If this works, then there would be
a macro preventing copy,paste across worksheets

 

[TKT-Tang]

Mr. Prabhuraaman,

Thank you for responding to my query.

The state of the matter remains,

1. Copy-and-Paste operations on the right-click mouse's short-cut menu
for
Sheet1 does not work (because Paste is greyed). A localized difficulty.

2. Copy-and-Paste operations on the right-click mouse's short-cut menu
for
other sheets do work quite well respectively.

3. Inter-sheet Copy-and-Paste operations would be pending.

4. Regards.