Technology and troubleshooting.

Tuesday, November 8, 2016

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.


Excel PasteSpecial grayed out
Solution:-
Step #1
Right Click the Sheet1->Open View Code-> Microsoft visual basic wizard will open
View Code
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

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

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