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
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 this information is useful for you. Please forgive any typos or incomplete sentences.
Hi, I followed those steps and it did not work. Is there any other way?
ReplyDeleteYou have to run it by hitting the play button in Microsoft Visual Basic for Applications.
ReplyDelete