How to fix Excel PasteSpecial grayed out

This tutorial describes how to fix Paste Special, Cut, Copy grayed out issue. This type issue may occurred while open the incompatible excel file which contions marco or working with ITR related excel sheet.

Solution:-

Step #1

Right Click the Sheet1->Open View Code-> Microsoft visual basic wizard will open

Step #2 

Paste the below the code in the code editor and HIT Enter

Public Sub Menu_Reset()
    CommandBars("column").Reset
    CommandBars("row").Reset
    CommandBars("Cell").Reset
 End Sub

That's all above code will reset to excel configuration to default.

I hope you this information is useful for you. Please forgive any typos or incomplete sentences.